Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: question on a "OCP reveiw question"
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=20
one.
I am reading OCP CRAM_EXAM book (author: Michael Ault) . I am confused =
by=20
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=20
privilege here? I don't remember anything particular between granting=20
privilege to a user or a role.
Thanks.
Guang
--=20
Author: Guang Mei
INET: zlmei_at_hotmail.com=20
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 Thu Aug 03 2000 - 17:04:47 CDT