Re: How to revoke select privilege on v$parameter

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? Received on Thu Feb 01 2007 - 06:33:55 CST