How to revoke select privilege on v$parameter
This is a discussion on How to revoke select privilege on v$parameter within the Oracle Database forums, part of the Database Server Software category; --> Hi, How to revoke select priviliges on v$parameter for a user I tried this as sysdba SQL> revoke select ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-26-2008, 03:51 AM
| ||||
| ||||
 How to revoke select privilege on v$parameter 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      |
|
02-26-2008, 03:51 AM
| |||
| |||
| Re: How to revoke select privilege on v$parameter On 1 Feb, 12:23, "Basavaraj Kirunge" <kiru...@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? |
|
02-26-2008, 03:51 AM
| |||
| |||
| Re: How to revoke select privilege on v$parameter On Feb 1, 5:33 pm, "gazzag" <gar...@jamms.org> wrote: > On 1 Feb, 12:23, "Basavaraj Kirunge" <kiru...@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 |
|
02-26-2008, 03:51 AM
| |||
| |||
| Re: How to revoke select privilege on v$parameter On Feb 1, 8:01 am, "Basavaraj Kirunge" <kiru...@gmail.com> wrote: > On Feb 1, 5:33 pm, "gazzag" <gar...@jamms.org> wrote: > > > On 1 Feb, 12:23, "Basavaraj Kirunge" <kiru...@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 -- |
|
02-26-2008, 03:52 AM
| ||||
| ||||
| Re: How to revoke select privilege on v$parameter On Feb 1, 8:48 pm, "Mark D Powell" <Mark.Pow...@eds.com> wrote: > On Feb 1, 8:01 am, "Basavaraj Kirunge" <kiru...@gmail.com> wrote: > > > > > > > On Feb 1, 5:33 pm, "gazzag" <gar...@jamms.org> wrote: > > > > On 1 Feb, 12:23, "Basavaraj Kirunge" <kiru...@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 --- Hide quoted text - > > - Show quoted text - Thanks, It worked now, actually access to v_$parameter was granted to PUBLIC. |
Linear Mode
