Re: to check READ/WRITE permissions on directory object in 10gR2 database
Date: Thu, 12 Nov 2009 19:43:53 +0000
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.
2009/11/12 Alex Fatkulin <afatkulin_at_gmail.com>
> 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_at_gmail.com> wrote:
> > Is there any view like DBA_TAB_PRIVS?