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

  • From: Alex Fatkulin <afatkulin@xxxxxxxxx>
  • To: anuragdba@xxxxxxxxx
  • Date: Thu, 12 Nov 2009 14:21:49 -0500

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

-- 
Alex Fatkulin,
http://afatkulin.blogspot.com
http://www.linkedin.com/in/alexfatkulin
--
//www.freelists.org/webpage/oracle-l


Other related posts: