User access to tables [message #249876] |
Fri, 06 July 2007 06:34 |
rons
Messages: 18 Registered: June 2007 Location: Scottland
|
Junior Member |
|
|
Hi,
How do I find out for which tables I have access.
USER_ALL_TABLES does not show anything. I dont have any tables.
Regards
Rons
|
|
|
|
Re: User access to tables [message #249909 is a reply to message #249876] |
Fri, 06 July 2007 08:43 |
rons
Messages: 18 Registered: June 2007 Location: Scottland
|
Junior Member |
|
|
Hi Michel,
Thanks fr your reply.
SQL> select owner, table_name from all_all_tables where table_name='EUL4_BAS';
OWNER TABLE_NAME
------------------------------ ------------------------------
OFSA_EULOWNER EUL4_BAS
SKP EUL4_BAS
WORKSHOP_U1 EUL4_BAS
KISSUP EUL4_BAS
6 rows selected.
SQL> select owner,table_name from user_tab_privs where table_name='EUL4_BAS';
no rows selected
SQL> select count(*) from OFSA_EULOWNER.EUL4_BAS;
COUNT(*)
----------
6
SQL>
In the above case, why the table shown in the all_all_tables and not in user_tab_privs. Also, I'm able to select data from OFSA_EULOWNER.EUL4_BAS. Could you please clarify my doubts.
Regards,
Rons
|
|
|
|