Xref: alice comp.databases.oracle.server:46168
Path: alice!news-feed.fnsi.net!news.idt.net!woodstock.news.demon.net!demon!bullseye.news.demon.net!demon!news.demon.nl!demon!sybrandb.demon.nl!not-for-mail
From: "Sybrand Bakker" <postbus@sybrandb.demon.nl>
Newsgroups: comp.databases.oracle.server
Subject: Re: Systemtable where roles are specified
Date: Fri, 16 Apr 1999 19:30:39 +0200
Organization: Bentley Systems Europe
Message-ID: <924283970.10652.0.rover.d4ee154e@news.demon.nl>
References: <7f792d$qq5@fs1.ilk.de>
X-Trace: news.demon.nl 924283970 rover:10652 NO-IDENT sybrandb.demon.nl:212.238.21.78
X-Complaints-To: abuse@demon.net
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Lines: 28

Hi Thomas,

If you need the system table you need amongst others objauth$. You can
easily find that by snooping in catalog.sql. That's way I address such
questions. Personally, I wouldn't use the tables directly (yes, I know, the
views are slow), because there is no guarantee whatsoever, they will stay
the same.

Hth anyway,

Sybrand Bakker, Oracle DBA

bombart@stadt-pforzheim.de wrote in message <7f792d$qq5@fs1.ilk.de>...
>Hello,
>
>Is there any systemtable, where roles are specified (inclusive grants to
>tables)?
>Oracle 7.3.5 Server.
>
>Greetings
>
>Thomas
>
>
>
>