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: current users enquiry

Re: current users enquiry

From: <gd6502_at_eudoramail.com>
Date: 15 Dec 2006 00:03:42 -0800
Message-ID: <1166169822.583272.276860@73g2000cwn.googlegroups.com>


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

Original text of this message

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