On Jul 9, 5:35 pm, sybra..._at_hccnet.nl wrote:
> On Mon, 09 Jul 2007 13:58:19 -0700, kartika.g..._at_gmail.com wrote:
> >Hi,
> >I gave scott select any table priviledge so that it could access 'apt'
> >tables. Now I have revoked the priviliedge but still scott can view
> >'apt' priviledge. Please can someone let me know what more I have to
> >do to stop scott from viewing 'apt' table? I am using 9.2 client and
> >server on aix.
>
> >Thanks in advance.
> >Kartika
>
> Likely you still have select privilege on those tables.
> Select owner, table_name, privilege, grantee
> from all_tab_privs
> where owner='APT'
>
> will show you who has granted the privilege, the so-called grantee.
>
> Note: the select any table privilege can be granted to a role, the DBA
> role is the most likely candidate.
>
> --
> Sybrand Bakker
> Senior Oracle DBA
Hi,
Thanks for you reply and the query. I will check this out.
Kartika
Received on Mon Jul 09 2007 - 20:30:52 CDT
