Skip to Content
0
Former Member
Jun 15, 2009 at 02:34 AM

Do not understand permssions on SAPDAT

221 Views

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:

Desc SAPDAT.user_tables

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