Home » RDBMS Server » Security » access control
access control [message #60243] Tue, 27 January 2004 04:06 Go to next message
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 Go to previous message
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
Previous Topic: URGENT!!!! SYS PASSWORD AND 9i!!!
Next Topic: Revoking all permissions from user
Goto Forum:
  


Current Time: Fri Mar 29 04:31:03 CDT 2024