Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: User Priviliges
You saw that in the manual ? (-;
"Mark Wijnands" <markw_at_ic.uva.nl> wrote in message
news:3BB45438.FD63626B_at_ic.uva.nl...
> 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 - 07:29:47 CDT