Re: How can you see who has some rights granted on an object ?

Check DBA_TAB_PRIVS for the information you seek. For example, try the following query:

  SELECT grantee,privilege
  FROM dba_tab_privs
  WHERE owner='myschema' AND table_name='myobject';

HTH,
Brian

Gb wrote:
>
> Hi,
>
> I am looking for a sql request that would bring the different rights granted
> to some users on a given objects.
> I have been looking on Oracle documentaion but didn't find anything.
>
> Thank you !
Received on Tue Aug 14 2001 - 07:39:12 CDT