Re: Systemtable where roles are specified

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 16 Apr 1999 19:30:39 +0200
Message-ID: <924283970.10652.0.rover.d4ee154e@news.demon.nl>

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_at_stadt-pforzheim.de wrote in message <7f792d$qq5_at_fs1.ilk.de>...
>Hello,
>
>Is there any systemtable, where roles are specified (inclusive grants to
>tables)?
>Oracle 7.3.5 Server.
>
>Greetings
>
>Thomas
>
>
>
>
Received on Fri Apr 16 1999 - 12:30:39 CDT