Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: View Granted User Privileges in SQLPLUS?

Re: View Granted User Privileges in SQLPLUS?

From: Sybrand Bakker <gooiditweg_at_nospam.demon.nl>
Date: Fri, 25 Apr 2003 19:42:08 +0200
Message-ID: <upsiav0pb0hu21jneoorv0drknd052sc1o@4ax.com> 





On 25 Apr 2003 07:49:58 -0700, gilgantic_at_yahoo.com (gilgantic) wrote:



>Is there a simple way to view granted privileges for a user in SQLPLUS?




Yes there is




select * from dict where table_name like '%PRIVS%' will show you the
correct views, and the manual will show them also




Sybrand Bakker, Senior Oracle DBA



To reply remove -verwijderdit from my e-mail address
Received on Fri Apr 25 2003 - 12:42:08 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US