| 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 |
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
