Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: current users enquiry
DA Morgan ha scritto:
> gd6502_at_eudoramail.com wrote:
> > I forgot...
> >
> > DA Morgan ha scritto:
> >> SELECT grantee, table_name, privilege
> >> FROM user_tab_privs_made;
> >>
> >> -- and for the other half of the equation:
> >> SELECT grantor, table_name, privilege
> >> FROM user_tab_privs_recd;
> >>
> >
> > The query both return an empty recordset.
> >
> > Peppe
>
> Then no object privileges have been granted or received
> by the schema owner.
So? This means I can't know if someone is accessing MY schema?
It seems so strange to me; every other db I know can do that. I was
thinking it's my guilt because of my insufficient competence about
using Oracle, but now...
Thanks everybody for help
Peppe Received on Fri Dec 15 2006 - 02:03:42 CST