which role or roles should you add the users?

You administer a database that has User A, B and C
User A must be able to create new tables and stored procedures, User B must be able to select,
update, delete and insert data.
User C must be able to provide windows logins to the database
To which role or roles should you add the users?

You administer a database that has User A, B and C
User A must be able to create new tables and stored procedures, User B must be able to select,
update, delete and insert data.
User C must be able to provide windows logins to the database
To which role or roles should you add the users?

A.
db_accessadmin

B.
db_ddladmin

C.
db_datawriter

D.
db_datareader

E.
db_owner

Explanation:



Leave a Reply 3

Your email address will not be published. Required fields are marked *


Suman

Suman

User A = db_ddladmin
User B= db_datawriter, db_datareader
User C = db_accessadmin

Kevin Burgess

Kevin Burgess

User A has alot more privilege than he should have…..with DB_DDLADMIN he can wreak quite a lot of havoc!

jin

jin

should it be User A = db_owner
User B= db_datawriter, db_datareader
User C = db_accessadmin