Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to revoke select privilege on v$parameter

Re: How to revoke select privilege on v$parameter

From: Basavaraj Kirunge <kirunge_at_gmail.com>
Date: 1 Feb 2007 05:01:54 -0800
Message-ID: <1170334914.769642.183690@k78g2000cwa.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US