Re: How to grant access to v$open_cursor

Jon;

Give him object privileges on V$OPEN_CURSOR to do a select.

Regards
Hans

"Jon Vahlberg" <jonov_at_iprimus.com.au> wrote in message news:3c9841e8$1_1_at_news.iprimus.com.au...
> Hi,
>
> I would like to grant a normal user access to v$open_cursor. I know you
can
> do it by granting them access to SELECT_CATALOG_* role but that gives them
> access to other v$ views - which I would prefer not to. Any thoughts?
>
> Jon.
>
>
>
Received on Wed Mar 20 2002 - 07:38:06 CST