Xref: alice comp.databases.oracle.server:46257
Path: alice!news-feed.fnsi.net!newsfeed1.earthlink.net!newsfeed.berkeley.edu!newsfeed1.uswest.net!news.uswest.net!not-for-mail
Message-ID: <371A9878.EE34FE92@uswest.net>
From: Marc Parkinson <marcpark@uswest.net>
X-Mailer: Mozilla 4.51 [en] (Win98; I)
X-Accept-Language: en
MIME-Version: 1.0
Newsgroups: comp.databases.oracle.server
Subject: Re: Systemtable where roles are specified
References: <7f7903$qq5@fs1.ilk.de>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 18
Date: Sun, 18 Apr 1999 20:44:08 -0600
X-Complaints-To: abuse@uswest.net
X-Trace: news.uswest.net 924489540 207.225.102.77 (Sun, 18 Apr 1999 21:39:00 CDT)
NNTP-Posting-Date: Sun, 18 Apr 1999 21:39:00 CDT
Organization: U S WEST Interprise

check for a dba_roles or all_roles view.

My info on this is at the office, so i an guessing.

Marc Parkinson

bombart@stadt-pforzheim.de wrote:

> Hello,
>
> Is there any systemtable, where roles are specified (inclusive grants to
> tables)?
> Oracle 7.3.5 Server.
>
> Greetings
>
> Thomas