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: DA Morgan <damorgan_at_psoug.org>
Date: Sun, 17 Dec 2006 13:41:11 -0800
Message-ID: <1166391668.142492@bubbleator.drizzle.com>


gd6502_at_eudoramail.com wrote:
> 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?

Sure you can. You can ask the DBA team.

You sure are acting like you've something to hide.

> It seems so strange to me; every other db I know can do that.

Every other db is not Oracle. <g>

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Sun Dec 17 2006 - 15:41:11 CST

Original text of this message

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