Home » SQL & PL/SQL » SQL & PL/SQL » check user permissions
check user permissions [message #443217] Sat, 13 February 2010 14:57 Go to next message
miroconnect@yahoo.com
Messages: 202
Registered: April 2006
Senior Member
my dba said he created a user app_internal
and granted persmission for select , update , delete for tables from a schema app.

I am using toad If I log in with app_internal I donot see any objects no tables no views no packages, no sequences nothing , so
does this this user is not given permissions to db objects from schema app?
I want make sure before I go and tell him permission are not given , how can I verify please tell me .
Re: check user permissions [message #443218 is a reply to message #443217] Sat, 13 February 2010 15:20 Go to previous messageGo to next message
BlackSwan
Messages: 24905
Registered: January 2009
Senior Member
SELECT TABLE_NAME , OWNER from all_tables;
Re: check user permissions [message #443219 is a reply to message #443218] Sat, 13 February 2010 15:37 Go to previous messageGo to next message
miroconnect@yahoo.com
Messages: 202
Registered: April 2006
Senior Member
this gives me owner and table names , but how can I find if user app_internal has permissions to tables whose owner is app?
Re: check user permissions [message #443220 is a reply to message #443219] Sat, 13 February 2010 15:57 Go to previous messageGo to next message
BlackSwan
Messages: 24905
Registered: January 2009
Senior Member
It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/
Re: check user permissions [message #443245 is a reply to message #443219] Sun, 14 February 2010 00:48 Go to previous messageGo to next message
Michel Cadot
Messages: 63804
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
miroconnect@yahoo.com wrote on Sat, 13 February 2010 22:37
this gives me owner and table names , but how can I find if user app_internal has permissions to tables whose owner is app?

Connect as the user app_internal and execute
select table_name, privilege where grantee = user and owner='APP';

Regards
Michel

Re: check user permissions [message #443361 is a reply to message #443219] Mon, 15 February 2010 05:19 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
By definition, you have SELECT privileges on all the tables you can see in the ALL_TABLES view.

If the privileges have been granted directly to you, then you should be able to look at the view USER_TAB_PRIVS.

The question is, if you believe that you don't have the required privileges, why have you brought this up here, rather than with your DBA?

Remember, you need to prefix the table name with the table owner if it's not your table or you don't have a synonym pointing at it.
Re: check user permissions [message #443363 is a reply to message #443361] Mon, 15 February 2010 05:41 Go to previous message
Michel Cadot
Messages: 63804
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
By definition, you have SELECT privileges on all the tables you can see in the ALL_TABLES view.

Not SELECT privilege but any privilege, at least one not necessary SELECT.

Regards
Michel
Previous Topic: How to improve the performance of this SP?
Next Topic: Script to retrieve Blobs from Database
Goto Forum:
  


Current Time: Mon Sep 26 16:19:56 CDT 2016

Total time taken to generate the page: 0.12555 seconds