| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: System Prievilieges
It seems these are for Trusted Oracle - Straight from the Oracle 8 Complete=
=20=
Reference :
WRITEDOWN - Allows CREATE, ALTER, DROP, INSERT, UPDATE or DELETE of objects=20= with access classes lower than the current session's (Trusted ORACLE)
READUP - Allows query of data with a higher access class than the current=20= session possesses (Trusted Oracle)
WRITEUP - Allows CREATE, ALTER, DROP, INSERT, UPDATE or DELETE of objects=20= 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=20= also part of Trusted Oracle=2E=20=
HTH Mark
-----Original Message-----
From: MIME :kgopalakrishnan_at_mantraonline=2Ecom=20= Sent: 22 June 2000 13:04 To: ORACLE-L_at_fatcity=2Ecom Subject: System Prievilieges
Hi !
Anybody has any ideas about the following System prievileges=2E
(taken from SQL=2EBSQ)
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
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=2Ecom (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L
 |
 |