Xref: alice comp.databases.oracle.server:46250 Path: alice!news-feed.fnsi.net!news.maxwell.syr.edu!wn4feed!worldnet.att.net!wnmaster1!not-for-mail From: KEVIN COOK Newsgroups: comp.databases.oracle.server Subject: Re: Systemtable where roles are specified Date: Sun, 18 Apr 1999 17:03:56 -0600 Organization: AT&T WorldNet Services Lines: 25 Message-ID: <371A64DC.75E505EB@ATT.NET> References: <7f792d$qq5@fs1.ilk.de> <37177106.1A38354C@us.oracle.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Trace: bgtnsc01.worldnet.att.net 924476379 9117 12.74.129.69 (18 Apr 1999 22:59:39 GMT) X-Complaints-To: abuse@worldnet.att.net NNTP-Posting-Date: 18 Apr 1999 22:59:39 GMT X-Mailer: Mozilla 4.51 [en] (Win98; I) X-Accept-Language: en,ja Pete Sharman wrote: > > Thomas > > There's a couple of things we need to know, because you're mixing some > terminology here. Do you want to find out what roles exist, in which case > you can use DBA/ALL/USER_ROLES to see what's there, SESSION_ROLES to see > what's active, DBA/ALL/USER_ROLE_PRIVS to see the actual privileges > granted? OR are you after direct grants to users, rather than through > roles, in which case DBA/ALL/USER_TAB_PRIVS are the views to look at? > > Just a minor point in addition - 7.3.5 doesn't exist to my knowledge. 7.3.4, > or 7.3.3.5, yes. > You are correct ... the 3 views for privs are XXX_tab_privs, XXX_role_privs XXX_sys_privs where XXX is DBA, ALL or USER According to Metalink ... Release 7.3.4 is the terminal release for Oracle7.... -Kevin Cook