Re: to check READ/WRITE permissions on directory object in 10gR2 database
- From: Joey D'Antoni <jdanton1@xxxxxxxxx>
- To: anuragdba@xxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Thu, 12 Nov 2009 11:17:34 -0800 (PST)
Anurag,
DBA_TAB_PRIVS is still there.
SQL*Plus: Release 10.2.0.4.0 - Production on Thu Nov 12 14:16:22 2009
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
OPS$ORACLE@ORCL> desc dba_tab_privs
Name Null? Type
----------------------------------------- -------- ----------------------------
GRANTEE NOT NULL VARCHAR2(30)
OWNER NOT NULL VARCHAR2(30)
TABLE_NAME NOT NULL VARCHAR2(30)
GRANTOR NOT NULL VARCHAR2(30)
PRIVILEGE NOT NULL VARCHAR2(40)
GRANTABLE VARCHAR2(3)
HIERARCHY VARCHAR2(3)
________________________________
From: Anurag Verma <anuragdba@xxxxxxxxx>
To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
Sent: Thu, November 12, 2009 2:14:24 PM
Subject: to check READ/WRITE permissions on directory object in 10gR2 database
Hi all,
In a 10g Release 2 database, how do I see, to which all users READ or WRITE
permissions are granted on a particular directory object?
Is there any view like DBA_TAB_PRIVS?
--
Anurag Verma,
Database Administrator
ERCOT(Electric Reliability Council of Texas),
Texas 76574
Other related posts:
