Re: View Granted User Privileges in SQLPLUS?

gilgantic_at_yahoo.com (gilgantic) wrote in message news:<d6052717.0304250649.15063d54_at_posting.google.com>...
> Is there a simple way to view granted privileges for a user in SQLPLUS?

connect to your database

 => Conn <username> / <password> @ <db>

Sql> select * from user_role_privs;

select * from dict where comments like '%privs%';

or

select * from dict where table_name like '%privs%'; Received on Fri Apr 25 2003 - 12:57:16 CDT