Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to revoke select privilege on v$parameter
On Feb 1, 5:33 pm, "gazzag" <gar..._at_jamms.org> wrote:
> On 1 Feb, 12:23, "Basavaraj Kirunge" <kiru..._at_gmail.com> wrote:
>
> > Hi,
> > How to revoke select priviliges on v$parameter for a user
> > I tried this as sysdba
> > SQL> revoke select on v_$parameter from user1
> > Revoke succeeded.
> > but the user1 is still able to access v$parameter table
>
> > Thanks,
> > Basavaraj K
>
> Does the user also have a ROLE assigned to it that also has SELECT
> privileges on the table?
No role is assigned to user1 Received on Thu Feb 01 2007 - 07:01:54 CST