On May 25, 7:29 pm, Andy Hassall <a..._at_andyh.co.uk> wrote:
> On 24 May 2007 13:59:45 -0700, Valentin Minzatu <valentinminz..._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 :: a...@andyh.co.uk ::http://www.andyh.co.ukhttp://www.andyhsoftware.co.uk/space:: disk and FTP usage analysis tool
Make sure you take a look at what the init file or pfile setting is
for utl_file_dir
Received on Fri May 25 2007 - 18:33:33 CDT
