Home » RDBMS Server » Server Administration » Access rights to the Dictionary by non-DBA users
Access rights to the Dictionary by non-DBA users [message #52562] Tue, 30 July 2002 03:20 Go to next message
Cristobal
Messages: 5
Registered: July 2002
Junior Member
Hi all,

I have an Oracle server for multiple customers, with every customer having 1 user, 1 data tablespace and 1 index tablespace, without quota outside their tablespaces. I don't want customers to see other schemas nor dictionary.

Each user has only "create session" granted, but they can make queries to the whole dictionary. Can I avoid that in some way ? Users querying the dictionary is a security issue from my point of view.

NOTE : I set the "O7_DICTIONARY_ACCESSIBILITY" to FALSE but same results.

Thanks in advance

Report message to a moderator

Re: Access rights to the Dictionary by non-DBA users [message #52566 is a reply to message #52562] Tue, 30 July 2002 05:23 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
thats wierd.
becuase by default, the normal users (non-dba users) can query only user_* tables, and certain all_* tables.
and a very Limited system tables.

Report message to a moderator

Previous Topic: Re: Automatic Execution os stored procedure(Urgent)
Next Topic: Help! Database hanging (Help!)
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Sep 19 04:11:06 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.