Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Minimum peivalage to let user see all session information
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
![]() |
![]() |