Determining Permissions for a User
by Frank Kim on Jul.23, 2007, under Oracle
SQL> select privilege from user_tab_privs where lower(table_name)=’t_foo’ and lower(grantee)=’frank’;
PRIVILEGE
—————————————-
UPDATE
SELECT
INSERT
DELETE
SQL> select * from user_role_privs;
USERNAME GRANTED_ROLE ADM DEF OS_
—————————— —————————— — — —
FRANK AQ_ADMINISTRATOR_ROLE NO YES NO
PUBLIC SELECT_CATALOG_ROLE NO YES NO
Related posts:
-
Innovate!
betweenGo is a web solutions provider, specializing in Ruby on Rails and ATG enabled solutions.
If you're interested in becoming a betweenGo client, please contact us.
Please feel free to join the discussion by leaving comments and stay updated by subscribing to the RSS feed.
You can also follow us on Twitter.
You can also subscribe by email by filling the field below:
