OraFAQ Forum: Server Administration » unable to find the table details from tab table with DBA role (merged 7)

Home » RDBMS Server » Server Administration » unable to find the table details from tab table with DBA role (merged 7) (oracle 10g)

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

unable to find the table details from tab table with DBA role (merged 7) [message #425794]

Mon, 12 October 2009 04:30

puspitaprusty
Messages: 1
Registered: October 2009
Location: Bangalore

Junior Member

Dear All,
I am unable to find the table details from tab table even though i am assigned to DBA role.Please suggest the solution for this.

SQL> select * from tab;

no rows selected

SQL>

SQL> select * from dba_roles;

ROLE PASSWORD
------------------------------ --------
CONNECT NO
RESOURCE NO
DBA NO
SELECT_CATALOG_ROLE NO
EXECUTE_CATALOG_ROLE NO
DELETE_CATALOG_ROLE NO
EXP_FULL_DATABASE NO
IMP_FULL_DATABASE NO
RECOVERY_CATALOG_OWNER NO
GATHER_SYSTEM_STATISTICS NO
LOGSTDBY_ADMINISTRATOR NO

ROLE PASSWORD
------------------------------ --------
AQ_ADMINISTRATOR_ROLE NO
AQ_USER_ROLE NO
GLOBAL_AQ_USER_ROLE GLOBAL
SCHEDULER_ADMIN NO
HS_ADMIN_ROLE NO
OEM_ADVISOR NO
OEM_MONITOR NO
WM_ADMIN_ROLE NO

19 rows selected.

[Updated on: Mon, 12 October 2009 04:48] by Moderator

Report message to a moderator

Re: unable to find the table details from tab table with DBA role [message #425796 is a reply to message #425794]

Mon, 12 October 2009 04:33

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Don't use "TAB" which is obsolete since almost 20 years.
Use DBA_TABLES.

Regards
Michel

[Updated on: Mon, 12 October 2009 04:34]

Report message to a moderator

Re: unable to find the table details from tab table with DBA role (merged 7) [message #425805 is a reply to message #425794]

Mon, 12 October 2009 04:49

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

STOP SPAMMING THE FORUM IN ALL SECTIONS WITH THE SAME QUESTION.

Regards
Michel

Report message to a moderator

Re: unable to find the table details from tab table with DBA role (merged 7) [message #426012 is a reply to message #425794]

Tue, 13 October 2009 12:53

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

puspitaprusty wrote on Mon, 12 October 2009 05:30

I am unable to find the table details from tab table even though i am assigned to DBA role.Please suggest the solution for this.

SQL> select * from tab;

no rows selected

Quite simply you may not have any tables in your schema. Roles have no correlation to what your query would return.

[edit] typo.

[Updated on: Tue, 13 October 2009 12:53]

Report message to a moderator

Previous Topic:	TableSpace Information (merged)
Next Topic:	Job Scheduling on Last Sun, Tue and Thu of every month

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jul 03 09:29:54 CDT 2024