question on a "OCP reveiw question" 
Author Message
 question on a "OCP reveiw question"

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

Sent via Deja.com http://www.***.com/
Before you buy.



Wed, 18 Jun 1902 08:00:00 GMT
 question on a "OCP reveiw question"

What they are getting at is there are some privs that can be
granted to a user but not to a role.  You can not assign the
following things to a role.

1. index privs
2. use the "with grant option"
3. reference

-Ethan
http://www.gnumetrics.com (Chart 100's of Oracle Stats)
http://www.freetechnicaltraining.com/oracle.htm

-----------------------------------------------------------

Got questions?  Get answers over the phone at Keen.com.
Up to 100 minutes free!
http://www.keen.com



Wed, 18 Jun 1902 08:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. question on a "OCP reveiw question"

2. max of ("...","...","..")

3. "Simple" Database Question

4. Cluster "isalive" Query security related question

5. Stupid question ("expression service")

6. Question about queries using "UNION"

7. Custom Task "DLL" question

8. Security Question with Administrative "SA"

9. Question about storing "date modified"

10. SQL "Property" Table Relationship Question

11. question about "top 1 *"

12. SQL "TOP" Question


 
Powered by phpBB® Forum Software