Home » RDBMS Server » Server Administration » LIST the privileges of a user
LIST the privileges of a user [message #371122] Thu, 31 August 2000 22:59 Go to next message
Radhesh Mohandas
Messages: 20
Registered: August 2000
Junior Member
Hi,
How can I list the privileges granted to a
a user? How can I find out which users have dba privileges?

Thanx

Radhesh
Re: LIST the privileges of a user [message #371134 is a reply to message #371122] Mon, 04 September 2000 19:36 Go to previous message
Irving
Messages: 13
Registered: September 2000
Junior Member
Hi,

check out the following static data dictionary views:

user_sys_privs - user system privileges
user_tab_privs - user tables privileges
user_tab_privs made- user table privileges made
user_tab_privs recd- user table privileges received

Regards =)
Previous Topic: OLE DB for Oracle 8.0.5
Next Topic: Backup software
Goto Forum:
  


Current Time: Sun May 26 18:27:01 CDT 2024