Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Minimum peivalage to let user see all session information

Re: Minimum peivalage to let user see all session information

From: sybrandb <sybrandb_at_gmail.com>
Date: 16 May 2007 04:29:46 -0700
Message-ID: <1179314986.279358.98700@p77g2000hsh.googlegroups.com>


On May 16, 1:18 am, "Sam" <ysa..._at_yahoo.com> wrote:
> Hi There,
> What is the minimum privilege that I can give a user to be able to see(Just
> select) all session information,
> without seeing other users/schemas objects?
> I tried:
> SELECT_CATALOG_ROLE
> also
> GRANT SELECT ANY DICTIONARY
>
> both of them worked but they alsso let them to see other Schema/Users
> objects like table name even structure of tables and procedures,
> How can I limit them to not seeing "other schema information" but see just
> Session information,
>
> Thank you in advance

define 'session information'
Any user by default can see all the tables etc.. he has been granted access too. Received on Wed May 16 2007 - 06:29:46 CDT

Original text of this message

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