OraFAQ Forum: Security » user account can't access dba_data

Home » RDBMS Server » Security » user account can't access dba_data_files

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

user account can't access dba_data_files [message #17304]

Wed, 05 January 2005 08:33

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

Report message to a moderator

Re: user account can't access dba_data_files [message #17305 is a reply to message #17304]

Wed, 05 January 2005 09:28

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.

Report message to a moderator

Re: user account can't access dba_data_files [message #17343 is a reply to message #17304]

Thu, 06 January 2005 17:59

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

Report message to a moderator

Previous Topic:	ORA-28007: the password cannot be reused
Next Topic:	Creating schemas with different roles.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 09 09:06:44 CST 2025