OraFAQ Forum: Security » revoke system privilege

Home » RDBMS Server » Security » revoke system privilege

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

revoke system privilege [message #57460]

Tue, 17 June 2003 08:34

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 ?

Report message to a moderator

Re: revoke system privilege [message #57467 is a reply to message #57460]

Tue, 17 June 2003 13:45

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

Report message to a moderator

Re: revoke system privilege [message #57472 is a reply to message #57467]

Wed, 18 June 2003 02:04

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

Report message to a moderator

Previous Topic:	Auditing in Oracle 9.2
Next Topic:	dbms_obfuscation_toolkit

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 24 07:44:58 CST 2025