RE: System Prievilieges

From: Kimberly Smith <kimberly.smith_at_gmd.fujitsu.com>
Date: Thu, 22 Jun 2000 08:14:28 -0700
Message-Id: <10536.110162@fatcity.com>

They are indeed all from bloody Trusted Oracle. Actually, its not the Trusted Oracle that is so bloody but the OS is pure hell.

-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of mleith_at_bradmark.co.uk
Sent: Thursday, June 22, 2000 7:06 AM
To: Multiple recipients of list ORACLE-L Subject: RE: System Prievilieges

It seems these are for Trusted Oracle - Straight from the Oracle 8 Complete Reference :

WRITEDOWN - Allows CREATE, ALTER, DROP, INSERT, UPDATE or DELETE of objects with access classes lower than the current session's (Trusted ORACLE)

READUP - Allows query of data with a higher access class than the current session possesses (Trusted Oracle)

WRITEUP - Allows CREATE, ALTER, DROP, INSERT, UPDATE or DELETE of objects with access classes higher than the current session's (Trusted ORACLE)

Havn't got a listing of the other 3, but I'm taking a guess that they are also part of Trusted Oracle.

HTH Mark

-----Original Message-----

From:	MIME :kgopalakrishnan_at_mantraonline.com Sent:	22 June 2000 13:04
To:	ORACLE-L_at_fatcity.com
Subject:	System Prievilieges

Hi !

Anybody has any ideas about the following System prievileges.
(taken from SQL.BSQ)

insert into SYSTEM_PRIVILEGE_MAP values (-194, 'WRITEDOWN DBLOW');
insert into SYSTEM_PRIVILEGE_MAP values (-195, 'READUP DBHIGH');
insert into SYSTEM_PRIVILEGE_MAP values (-196, 'WRITEUP DBHIGH');
insert into SYSTEM_PRIVILEGE_MAP values (-197, 'WRITEDOWN');
insert into SYSTEM_PRIVILEGE_MAP values (-198, 'READUP');
insert into SYSTEM_PRIVILEGE_MAP values (-199, 'WRITEUP')

What are these privilegess

WRITEDOWN DBLOW
READUP DBHIGH
WRITEUP DBHIGH
WRITEDOWN
READUP
WRITEUP

Author: kgopalakrishnan INET: kgopalakrishnan_at_mantraonline.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).

<< File: ENVELOPE.TXT >> --
Author:
INET: mleith_at_bradmark.co.uk

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------