Path: news.f.de.plusline.net!news-fra1.dfn.de!kanaga.switch.ch!switch.ch!news.in2p3.fr!in2p3.fr!proxad.net!216.239.36.134.MISMATCH!postnews.google.com!l53g2000cwa.googlegroups.com!not-for-mail
From: "Basavaraj Kirunge" <kirunge@gmail.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: How to revoke select privilege on v$parameter
Date: 1 Feb 2007 22:48:09 -0800
Organization: http://groups.google.com
Lines: 37
Message-ID: <1170398889.693796.279000@l53g2000cwa.googlegroups.com>
References: <1170332632.244410.158130@a75g2000cwd.googlegroups.com>
   <1170333234.977361.84890@a34g2000cwb.googlegroups.com>
   <1170334914.769642.183690@k78g2000cwa.googlegroups.com>
   <1170344895.510693.27340@m58g2000cwm.googlegroups.com>
NNTP-Posting-Host: 148.87.1.170
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1170398894 28994 127.0.0.1 (2 Feb 2007 06:48:14 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Fri, 2 Feb 2007 06:48:14 +0000 (UTC)
In-Reply-To: <1170344895.510693.27340@m58g2000cwm.googlegroups.com>
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; (R1 1.5); .NET CLR 2.0.50727; .NET CLR 1.1.4322),gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: l53g2000cwa.googlegroups.com; posting-host=148.87.1.170;
   posting-account=KULfFg0AAAAGblIXhSNCxOEzb9bBA3qu
Xref: news.f.de.plusline.net comp.databases.oracle.server:193484

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.