Re: privileged users on Directory Objects

On 24 May 2007 13:59:45 -0700, Valentin Minzatu <valentinminzatu_at_yahoo.com> wrote:

>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>

 You'd need more filters on that, such as "OWNER = 'SYS'" (which owns directory objects), and the READ and/or WRITE privileges (since you can have other objects with the same name, but they'll have different privileges like SELECT).

-- 
Andy Hassall :: andy@andyh.co.uk :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool