Home » RDBMS Server » Server Administration » unable to find the table details from tab table with DBA role (merged 7) (oracle 10g)
unable to find the table details from tab table with DBA role (merged 7) [message #425794] Mon, 12 October 2009 04:30 Go to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 63804
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 Go to previous messageGo to next message
Michel Cadot
Messages: 63804
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

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

Regards
Michel
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 Go to previous message
joy_division
Messages: 4616
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:
  


Current Time: Mon Sep 26 12:53:56 CDT 2016

Total time taken to generate the page: 0.10915 seconds