COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
the sysadmin
|
|
|
the Localadmin
|
|
|
the globaladmin
|
|
|
None of the above
|
Detailed explanation-1: -Members of the sysadmin fixed server role can perform any activity in the server. Members of the serveradmin fixed server role can change server-wide configuration options and shut down the server.
Detailed explanation-2: -What fixed database role would you use to manage database-level security roles and permissions? db securityadmin-This role can manage database-level security (roles and permissions).
Detailed explanation-3: -A service account is a user account that Windows services use to log on to a computer or domain with a specific set of rights and permissions.
Detailed explanation-4: -What is the principle of least privilege? The principle of least privilege works on the basis of users and systems having the bare minimum privileges needed to carry out their jobs. Minimizing each user’s level of access is a defensive strategy against data exploitation.