Re: current users enquiry

From: DA Morgan <damorgan_at_psoug.org>
Date: Wed, 13 Dec 2006 09:07:22 -0800
Message-ID: <1166029642.905418@bubbleator.drizzle.com>

gd6502_at_eudoramail.com wrote:
> DA Morgan ha scritto:

>> v$ "magic" views are owned by SYS. You need to have a DBA run the
>> query for you.
>> --

>
> So, there is no way for a common user to know if the schema he is using
> is accessed from some other?
>
> Peppe

Not at all.

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;

But if you are concerned about access from those who have been given the privileges such as SELECT ANY TABLE by a DBA you are out of luck. That is for the DBAs to know and control.

If you can't ask your question of a DBA it strikes me you are doing something you wish to hide from your employer: A very bad idea.

-- 
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 Wed Dec 13 2006 - 11:07:22 CST