RE: Privileges

From: Jack C. Applewhite <japplewhite_at_inetprofit.com>
Date: Fri, 19 Oct 2001 06:04:36 -0700
Message-ID: <F001.003AFB5B.20011019051520@fatcity.com>

Dave,

By "relevant section" I assume you mean under GRANT in "Oracle8i SQL Reference". Table 11-1 "System Privileges" is self-explanatory while tables 11-3 and 11-4 cover object privileges.

For a full explanation of what any particular privilege implies, you'll have to dig into the docs and find the sections dealing with the "thing" on which the privilege is based. For example, you'll have to read about Application Context to understand what "CREATE ANY CONTEXT" (Create any context namespace) implies - see "Oracle8i Application Developer's Guide - Fundamentals" for details on Application Context and Fine-Grained Access Control.

I'm not sure that a single list could explain enough without becoming a lengthy tome, though Oracle certainly could have done better (at least some links to relvant sections) in the GRANT tables of privileges.

Jack

Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
japplewhite_at_inetprofit.com
(512)327-9068

-----Original Message-----
Sent: Friday, October 19, 2001 7:05 AM
To: Multiple recipients of list ORACLE-L

Hi,

Can anyone point me in the direction of a list of privileges (version 8.1.7) and their meanings. Obviously most are self explanatory but there are a few I'm not too sure about. I tried using the Java Search facility in the Oracle documentation but this only points me to the relevant section and does not highlight where in the section the search words are. I have also tried Metalink and could not find a definitive list.

Any help would be appreciated.

Dave Leach

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jack C. Applewhite
  INET: japplewhite_at_inetprofit.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).

Received on Fri Oct 19 2001 - 08:04:36 CDT