Re: privileged users on Directory Objects

On May 24, 4:41 pm, Pedro Lopes <pedro.lo..._at_netvisao.pt> wrote:
> Hi all,
> how can I check the users that have privileges on a certain Directory
> (object) ?
>
> thanks,
> pedro

This will give both users and roles:

SELECT grantee
  FROM dba_tab_privs
 WHERE table_name = <directory_name> Received on Thu May 24 2007 - 15:59:45 CDT