Re: to check READ/WRITE permissions on directory object in 10gR2 database

Just remember that Directories have always been half-baked kind of objects -
not associated with a regular schema - so they appear in ALL_DIRECTORIES,
ALL_TAB_PRIVS etc as owned by SYS.

Regards Nigel

2009/11/12 Alex Fatkulin <afatkulin@xxxxxxxxx>

> It's all still in there (dba_TAB_privs is a bit confusing as a name, yes)
>
> select *
>        from dba_tab_privs p, dba_directories d
>        where p.owner = d.owner
>                and p.table_name = d.directory_name;
>
> On Thu, Nov 12, 2009 at 2:14 PM, Anurag Verma <anuragdba@xxxxxxxxx> wrote:
> >
> > Is there any view like DBA_TAB_PRIVS?
> >
>
>

Other related posts: