COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
bulkadmin
|
|
|
securityadmin
|
|
|
processadmin
|
|
|
None of the above
|
Detailed explanation-1: -The securityadmin role should be treated as equivalent to the sysadmin role.
Detailed explanation-2: -The “sysadmin” fixed server role is designed to provide accounts assigned to the role full control over all aspects of the SQL Server instance it is a part of. By default, the sa account is assigned to the sysadmin role, making it a prime target for attackers.
Detailed explanation-3: -Fixed Server Roles The role bulkadmin gives administers bulk copy and other bulk operations. The role dbcreator allows its members to create, alter, or drop databases. The diskadmin role allows its members to work with the actual files on the disk-for instance, it could manage filegroups.
Detailed explanation-4: -Members of the db owner fixed database role can perform all configuration and maintenance activities on the database, and can also drop the database in SQL Server. (In SQL Database and Azure Synapse, some maintenance activities require server-level permissions and cannot be performed by db owners.)
Detailed explanation-5: -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).