Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: question on a "OCP reveiw question"

Re: question on a "OCP reveiw question"

From: <srinivas.katta_at_hartfordlife.com>
Date: Fri, 4 Aug 2000 11:36:50 -0400
Message-Id: <10579.113868@fatcity.com>


This is my take on the following subject.

Object Privileges Corresponding System privileges.

  1. Alter a. Alter any
  2. Delete b. Delete any
  3. Index c. Index any
  4. Insert d. Insert any

As per the explanation below, the Index Privilege cannot be granted to the role. Hence the question
Which privilege can only be granted to a user?

An extract from Release 7.1

Each type of object has different privileges associated with it. Table 12 - 2 summarizes the object privileges available for each type of object.

 Object Privilege                Table                      View                           Sequence                                    Procedure1
 ALTER                                 _/                                                                    _/
 DELETE                              _/                          _/
 EXECUTE
                                                                                                                                                           

/
 INDEX                                _/2
 INSERT                              _/                           _/
 REFERENCES                _/2
 SELECT                            _/                          _/3                                      _/
 UPDATE                           _/                          _/

Table 12 - 2. Object Privileges

 1 Includes stand-alone stored procedures and functions, and public package constructs.  2 Privilege cannot be granted to a role.  3 Can also be granted for snapshots.

"Rachel Carmichael" <carmichr_at_hotmail.com>@fatcity.com on 08/04/2000 10:47:15 AM

Please respond to ORACLE-L_at_fatcity.com

Sent by: root_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc:

Subject: Re: question on a "OCP reveiw question"

Roles can't own objects. So a role cannot create an index....

>From: "Nechama Glasrot" <Nglasrot_at_co.palm-beach.fl.us>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Re: question on a "OCP reveiw question"
>Date: Thu, 03 Aug 2000 15:15:25 -0800
>
>i believe the answer is correct because alter, delete, and insert are
>object privileges and are yours by default as owner of the object whereas
>you have to be granted index explicitly by the DBA as it is a system
>privilege ... any corrections will be appreciated
>
>thank you ...
>
>Nechama Glasrot
>DBA
>COC Automation Services - Palm Beach County
>nglasrot_at_co.palm-beach.fl.us
>561-355-3467
>
> >>> "Guang Mei" <zlmei_at_hotmail.com> 08/03 12:35 PM >>>
>Hi:
>Thanks for everyone who answered my previous questions. Now I have a new
>one.
>I am reading OCP CRAM_EXAM book (author: Michael Ault) . I am confused by
>the following practice question:
>
>Which privilege can only be granted to a user?
>a. Alter
>b. Delete
>c. Index
>d. Insert
>
>Book's answer is c.
>
>Could anyone tell me why? Are we taking about system privilege or object
>privilege here? I don't remember anything particular between granting
>privilege to a user or a role.
>
>Thanks.
>
>Guang
>________________________________________________________________________
>Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
>
>--
>Author: Guang Mei
> INET: zlmei_at_hotmail.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).
>
>--
>Author: Nechama Glasrot
> INET: Nglasrot_at_co.palm-beach.fl.us
>
>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).



Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
--
Author: Rachel Carmichael
  INET: carmichr_at_hotmail.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
Received on Fri Aug 04 2000 - 10:36:50 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US