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.