Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 70-028 question

Author  Topic 

jeroena
Yak Posting Veteran

76 Posts

Posted - 2002-11-21 : 04:44:47
Hi,

I'm taking 70-028 this afternoon. In a cramsession I came along this question:

Eric needs to manage user accounts on the HumanResources database.
Which minimum role can you apply to him?

A db_owner
B db_accessadmin
C securityadmin
D db_securityadmin
E serveradmin

C en E are fixed server roles so they drop out. I thought it was A because because I think "managing" alse meens adding and removing database users (B) AND giving permissions etc... But it's suppose to be D. In SQL Books online the description for db_securityadmin indeed sais "manage". hmmm, tricky.

Hey, I thought I had a question. Well, any comments are welcome. And tips for my 70-028 exam of course!

Cya, Spike.

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2002-11-21 : 07:06:39
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=21782

Damian
Go to Top of Page
   

- Advertisement -