I have an account with select_catalog_role in SAP BI 7.0 Oracle Database.
I found that most of the SAP tables are in SAPDAT schema.
In sqlplus., When I say:
It shows me definition of user_tables
But when I say
Select * from SAPDAT.user_tables
I get Oracle error:
select * from SAPDAT.user_tables
ERROR at line 1:
ORA-00942: table or view does not exist
Why? I thought if I have select_catalog_role I should be able to view anything