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.

Report message to a moderator

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';


Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Feb 13 16:29:25 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.