| Author |
1z0-023 question needs help!
|
|
| sid456 2002-03-02, 7:44 pm |
| How would you temporary revoke a role from a user?
A. Drop the role
B. Disable the role.
C. Revoke the role from the user
Not sure whether should be A or B
Please help. | |
| laloca 2002-03-03, 6:51 am |
| Hi Sid,
not sure here, but I'd say c is correct (isn't there a 4. answer?).
IMHO the correct answer could also be an ALTER USER statement ...
"The following statement makes all roles granted directly to scott default roles, except the agent role:
ALTER USER scott
DEFAULT ROLE ALL EXCEPT agent;
At the beginning of scott's next session, Oracle enables all roles granted directly to scott except the agent role."
Answer a. is wrong, because dropping a role isn't temporary ;-)
Answer b. is wrong, because there is no ALTER ROLE ... DISABLE statement.
Answer c. would be as efficient than the alter user statement and wouldn't change the grants for other users using the same role .. I would use the revoke <role> from <user>, because it's straight forward 
Any other opinions from OCP's?  | |
| aneesh_bhatia 2002-03-03, 7:39 am |
| quote:
Originally posted by sid456
How would you temporary revoke a role from a user?
A. Drop the role
B. Disable the role.
C. Revoke the role from the user
Not sure whether should be A or B
Please help.
Given the choice:
'C' seems to be the best answer. | |
| sid456 2002-03-05, 2:03 am |
| Thanks again. Just passed 023 to-day! | |
| aneesh_bhatia 2002-03-05, 2:22 am |
| quote:
Originally posted by sid456
Thanks again. Just passed 023 to-day!
Congrats man!
How was it, I will hopefully give it in about a month or so. How did you prepare for it? How long did it take to prepare? Let us know!!!
Cheers! | |
| sid456 2002-03-05, 4:23 pm |
| I used Sybex gudie book and notes from a
lady friend on this board plus the STS practice set.
Read your message box, buddy! | |
| dhcpserver 2002-03-05, 6:28 pm |
| c00l, well done
May I have a copy of your notes, Laloca, please | |
| laloca 2002-03-06, 1:18 pm |
| Congratulations, Sid! 
Nice to hear that my notes were useful ... ... no problem to share them - they are GNU !! | |
| aneesh_bhatia 2002-03-06, 2:58 pm |
| quote:
Originally posted by laloca
Congratulations, Sid!
Nice to hear that my notes were useful ... ... no problem to share them - they are GNU !!
Hi LaLoca,
Could be you be so kind as to share your notes with me!! They would be of enormous assistance!! Maybe I can learn a thing or two on how to make notes.
Cheers! | |
| laloca 2002-03-06, 3:37 pm |
| aneesh_bhatia and dhcpserver:
to which email addresses should I send the notes? it's about 120 pages in Word - 279 KB ZIP-file.
laloca@warum.net | |
| aneesh_bhatia 2002-03-06, 4:16 pm |
| quote:
Originally posted by laloca
aneesh_bhatia and dhcpserver:
to which email addresses should I send the notes? it's about 120 pages in Word - 279 KB ZIP-file.
laloca@warum.net
laloca,
I have sent you an email... | |
| laloca 2002-03-06, 4:21 pm |
| Aneesh,
I already replied .. | |
| aneesh_bhatia 2002-03-07, 12:21 am |
| quote:
Originally posted by laloca
Aneesh,
I already replied ..
Thanks Laloca
The notes look FANTASTIC! |
|
|
|