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

Report message to a moderator

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 =)

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Dec 22 10:22:30 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.