| access control [message #60243] |
Tue, 27 January 2004 04:06  |
David
Messages: 110
Registered: November 1998
|
Senior Member |
|
|
hello all,
Would like to seek the expertise of everyone here and i am a newbie. I am trying to find out the list of users who is granted access to the Oracle database. In other words, how can i list a list of users who is granted access to the database? Thanks
|
|
|
|
| Re: access control [message #60251 is a reply to message #60243] |
Tue, 27 January 2004 08:22  |
Thiru
Messages: 1089
Registered: May 2002
|
Senior Member |
|
|
Hi,
your requirement is not clear. 'granted access to the database' is a pretty generic term.
For eg, to find out who is granted 'CREATE SESSION' privilege explicitly( ie the privilege to establish a session to the database)
select grantee from dba_sys_privs where privilege='CREATE SESSION';
But the CREATE SESSION privilege is also granted to 'CONNECT' role which in turn might be granted to users.
select grantee from dba_role_privs where GRANTED_ROLE='CONNECT';
these users can connect to the database. For object privileges granted explicitly, query dba_tab_privs.
For roles granted , query dba_role_privs.
For system privileges, query dba_sys_privs
and so on..
-Thiru
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
