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