Home » RDBMS Server » Server Administration » user permissions
user permissions [message #143938] Mon, 24 October 2005 05:27 Go to next message
Zakkhalid
Messages: 47
Registered: April 2005
Member
Hi All,

I have a user (zak) that has synonyms to another user's (fred) tables. How can I find what permissions zak has on fred's tables.

Thanking you all inadvance.

Re: user permissions [message #143943 is a reply to message #143938] Mon, 24 October 2005 05:58 Go to previous message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member


Run this query on Zak's schema

SQL> select * from user_tab_privs 
  2  where owner='FRED'
  3  and table_name='your_table_name';



Previous Topic: Use of NOLOGGING ...!!!
Next Topic: Why I don't see any records in dba_db_links
Goto Forum:
  


Current Time: Fri Jan 10 12:54:29 CST 2025