Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: User Priviliges

Re: User Priviliges

From: Mark Wijnands <markw_at_ic.uva.nl>
Date: Fri, 28 Sep 2001 12:41:37 +0200
Message-ID: <3BB453E1.49B53CEB@ic.uva.nl>


Hello Thiko.

In my opinion you can gather all the information you need by using the database-views:

dba_role_privs    - Information about the roles of a db-user.
dba_sys_privs    - Information about the system privileges of a db-user.
dba_user_privs    - Information about the object privileges of a db-user.

Reading a manual would also help ;-)

GrtZ, Mark.

Thiko wrote:

> Hi
>
> What are all the data dictionaries to query on to find what privileges
> particular database users may have.
>
> I know of user_tab_privs.
>
> Many thanks.
>
> Thiko!
Received on Fri Sep 28 2001 - 05:41:37 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US