Home » RDBMS Server » Security » user account can't access dba_data_files
user account can't access dba_data_files [message #17304] Wed, 05 January 2005 08:33 Go to next message
Monica
Messages: 37
Registered: February 2000
Member
I created a user account "checkdb".
sqlplus checkdb/pass
select * from dba_data_files;
ERROR at line 1:
ORA-00942: table or view does not exist

I have give checkdb "Select on any table" privs.

Query works fine if I log in as system.
SQL> SELECT OWNER, OBJECT_TYPE
2 FROM DBA_OBJECTS
3 WHERE OBJECT_NAME = 'DBA_DATA_FILES';

OWNER OBJECT_TYPE
------------------------------ ------------------
SYS VIEW
PUBLIC SYNONYM
SYSTEM SYNONYM
Re: user account can't access dba_data_files [message #17305 is a reply to message #17304] Wed, 05 January 2005 09:28 Go to previous messageGo to next message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
From 8.0.4 on, the SELECT ANY TABLE privilege does not apply to SYS-owned objects, such as DBA_DATA_FILES. Instead, use the SELECT ANY DICTIONARY privilege.
Re: user account can't access dba_data_files [message #17343 is a reply to message #17304] Thu, 06 January 2005 17:59 Go to previous message
Fahami
Messages: 22
Registered: December 2004
Junior Member
Hi,

You can do select to a view provided to common users instead of dba. The view is V$DATAFILE
Previous Topic: ORA-28007: the password cannot be reused
Next Topic: Creating schemas with different roles.
Goto Forum:
  


Current Time: Wed Dec 08 22:07:43 CST 2021