Re: current users enquiry

DA Morgan ha scritto:

> 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.

Nothing to hide. My application sometimes (for new releases tipically) needs to update the db structure, so it should check, before starting, that nobody is using the db. I am not the DBA of course, and the application only uses the parameters (and rights) that the customer's technical support chooses itself.

Peppe Received on Thu Dec 14 2006 - 06:09:41 CST