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:
User A = db_ddladmin
User B= db_datawriter, db_datareader
User C = db_accessadmin
User A has alot more privilege than he should have…..with DB_DDLADMIN he can wreak quite a lot of havoc!
should it be User A = db_owner
User B= db_datawriter, db_datareader
User C = db_accessadmin