Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: User Priviliges
Sorry, I mean dba_tab_privs instead of dba_user_privs :-)
GrtZ.
Mark Wijnands wrote:
> 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:43:04 CDT