Home » RDBMS Server » Security » revoke system privilege
revoke system privilege [message #57460] Tue, 17 June 2003 08:34 Go to next message
David
Messages: 110
Registered: November 1998
Senior Member
When i create a user with create session and unlimited tablespace, the user can see some public views and tables as v$version, v$option, dual, audit_actions, etc etc ...

But we want that the user can't see theses public tables and views . Is it possible and how to do ?
Re: revoke system privilege [message #57467 is a reply to message #57460] Tue, 17 June 2003 13:45 Go to previous messageGo to next message
Raju Angani
Messages: 5
Registered: June 2003
Junior Member
Hi David,

Set 07_DICTIONARY_ACCESSIBILITY = FALSE in init.ora.

This should solve your problem.

-Raju
Re: revoke system privilege [message #57472 is a reply to message #57467] Wed, 18 June 2003 02:04 Go to previous message
David
Messages: 110
Registered: November 1998
Senior Member
Thanks a lot Raju ,

but 07_DICTIONARY_ACCESSIBILITY is at False by default in 9i.
The problem is that the users could do a "select" from all_tables and all_views, so they can view public synonyms view and tables.

It's difficult to hide and/or forbid the access to these public tables at the users.

thanks for u're response
Previous Topic: Auditing in Oracle 9.2
Next Topic: dbms_obfuscation_toolkit
Goto Forum:
  


Current Time: Sat Sep 18 19:53:14 CDT 2021