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
How can I list the privileges granted to a
a user? How can I find out which users have dba privileges?


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
Messages: 13
Registered: September 2000
Junior Member

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