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

From: Nigel Thomas <nigel.cl.thomas_at_googlemail.com>
Date: Thu, 12 Nov 2009 19:43:53 +0000
Message-ID: <53258cd50911121143i25b3af01mf05226197a7b419_at_mail.gmail.com>

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

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Nov 12 2009 - 13:43:53 CST