Topic: Database Administration >> ask on the roles
|
Disclaimer: The purpose of all dbapool forums including OCP and Other Oracle Certification forums is to help each other with specific issues but not to share dump and copyrighted exam content, materials or intellectual property.
You may review the entire Oracle Certification Program Candidate Agreement online Here.
|
|
|
|
| electronic |
Posted: Jun 18, 2007 01:00:50 PM |
Total Post: 21
Joined: Feb, 2007
|
you executed the following command to grant the CONNECT role to the USER01
SQL> grant CONNECT to USER01 with admin option
which of the following sentences truth is?
A)The user can grant the role to any database user but cannotrevoke it.
B)The user can grant or revoke the role to or from any database user.
C)The user can grant or revoke the role to or from any database user
exceptthe SYS and SYSTEM users.
D)The user can revoke the role from any database user but cannot grant
it.
E)The statement fails because the CONNECT role cannot be granted WITH
ADMIN OPTION.
|
|
|
 Ratnaker |
| Posted: Jun 19, 2007 06:37:41 AM |  |
|
Total Post: 141
Joined: Apr, 2007
|
Hi,
First option is correct.
The grantee can grant or revoke the system privilege or role to or from any user or other role in the database. Users cannot revoke a role from themselves.
K P Ratnaker
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
|
|
|
|
Forum Rules & Description
Who Can Read The Forum? Any registered user or guest
Who Can Post New Topics? Any registered user
Who Can Post Replies? Any registered user
|
| |
Get FREE Magazines
|
Top 10 Forum User
|
| Murtuja Khokhar | 857 |
| Mohammed Taj | 746 |
| positive fanatic | 483 |
| Jayanta Sur | 479 |
| Vigyan Kaushik | 386 |
| Gopu Gopi | 333 |
| Gitesh Trivedi | 322 |
| Vinoth Kumar | 264 |
| neeraj sharma | 258 |
| Ramesh Jois | 246 |
|
|
