OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » sys tables

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

sys tables [message #64381]

Thu, 20 January 2005 13:33

Miguel
Messages: 14
Registered: April 2001

Junior Member

when i try to select any table from schema sys i always get the same message that the table dont exist. I also gave the role SELECT_CATALOG_ROLE but it doesn´t work.

may i have to alter any parameter or something else?

the release is 9.2.0.5

Report message to a moderator

Re: sys tables [message #64387 is a reply to message #64381]

Thu, 20 January 2005 22:37

Frank Naude
Messages: 4587
Registered: April 1998

Senior Member

So, what error do you get? Do you select from SCHEMA.TABLE_NAME or just TABLE_NAME? It may help if you show us exactly what you are doing.

Best regards.

Frank

Report message to a moderator

Re: sys tables [message #64398 is a reply to message #64387]

Fri, 21 January 2005 07:31

Miguel
Messages: 14
Registered: April 2001

Junior Member

hi again, i´m doing this query:

select sys.user$.user#, name, ext_username
from sys.user$
where sys.user$.type# = 0

i get this message:

ORA-00942 table or view does not exist

but the object exist because i can find it using

select * from dba_tables where table_name = 'USER$' or
select * from dba_objects where object_name = 'USER$'

i´m using a user that have the select any table and select_catalog_role

Report message to a moderator

Re: sys tables [message #64412 is a reply to message #64398]

Mon, 24 January 2005 02:54

Frank Naude
Messages: 4587
Registered: April 1998

Senior Member

You also need to grant SELECT ANY DICTIONARY:

SQL> grant select any dictionary to scott;

Grant succeeded.

Best regards.

Frank

Report message to a moderator

Re: sys tables [message #64431 is a reply to message #64412]

Fri, 28 January 2005 05:52

Miguel
Messages: 14
Registered: April 2001

Junior Member

thanks

Report message to a moderator

Previous Topic:	Historical Tables & Maintaining Fkey
Next Topic:	How much memory taken from SGA when connect a User

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 10 03:59:52 CST 2025