Re: Minimum peivalage to let user see all session information

On May 15, 6:18 pm, "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

Were you not relying upon the 'lazy man's way' of doing this you'd have realised granting select on sys.v_$session would do what you ask.

David Fitzjarrell Received on Wed May 16 2007 - 08:05:03 CDT