Re: v$parameter

From: Nuno Souto <nsouto_at_acay.com.au>
Date: Mon, 21 Dec 1998 22:23:51 +1100
Message-ID: <367e3099.0@job.acay.com.au>

That may be so. But I've found that not all role access is suspended. I've got stored procedures that are quite happy with access to other schema tables. But when I add a reference to a sequence, the role fails.

I wish the whole thing would be consistent. That used to be one of the great things with ORACLE. Nowadays, it seems they have caught Microsoftitis...

--
Cheers
Nuno Souto
nsouto_at_acay.com.au
Roger Snowden wrote in message <367BF7DC.D5BD1DBD_at_NOT.com>...
>
>Access to this sys-owned view was probably granted via a role. Roles are
>suspended during stored procedure execution under the current releases.
>To fix this, log in as sys and explicitly grant select on this view to
>the procedure owner.
Received on Mon Dec 21 1998 - 05:23:51 CST