Re: How to revoke select privilege on v$parameter

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 1 Feb 2007 07:48:15 -0800
Message-ID: <1170344895.510693.27340@m58g2000cwm.googlegroups.com>

On Feb 1, 8:01 am, "Basavaraj Kirunge" <kiru..._at_gmail.com> wrote:
> 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

Check the grants that have been issued on sys.v_$parameter via sys.dba_tab_privs and make sure it does not show as being granted to the user or to PUBLIC.

HTH -- Mark D Powell -- Received on Thu Feb 01 2007 - 09:48:15 CST