Home » RDBMS Server » Server Administration » User access to tables
User access to tables [message #249876] Fri, 06 July 2007 06:34 Go to next message
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 #249894 is a reply to message #249876] Fri, 06 July 2007 08:08 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
USER_ALL_TABLES describes the object tables and relational tables owned by the current user.

To get the objects you have access you have to use:
Quote:
ALL_ALL_TABLES describes the object tables and relational tables accessible to the current user.


Regards
Michel
Re: User access to tables [message #249909 is a reply to message #249876] Fri, 06 July 2007 08:43 Go to previous messageGo to next message
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
Re: User access to tables [message #249911 is a reply to message #249909] Fri, 06 July 2007 08:48 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Privilege given to PUBLIC?

Regards
Michel
Previous Topic: Insert Special Characters into Oracle10g
Next Topic: consolidation
Goto Forum:
  


Current Time: Sat Dec 10 20:38:30 CST 2016

Total time taken to generate the page: 0.08424 seconds