Re: to check READ/WRITE permissions on directory object in 10gR2 database
From: Alex Fatkulin <afatkulin_at_gmail.com>
Date: Thu, 12 Nov 2009 14:21:49 -0500
Message-ID: <49d668000911121121u566a60b0o4f6f388d3ae59880_at_mail.gmail.com>
It's all still in there (dba_TAB_privs is a bit confusing as a name, yes)
Date: Thu, 12 Nov 2009 14:21:49 -0500
Message-ID: <49d668000911121121u566a60b0o4f6f388d3ae59880_at_mail.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?
>
-- Alex Fatkulin, http://afatkulin.blogspot.com http://www.linkedin.com/in/alexfatkulin -- http://www.freelists.org/webpage/oracle-lReceived on Thu Nov 12 2009 - 13:21:49 CST