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
Received on Fri Aug 04 2000 - 08:38:04 CDT
