25.6k views
1 vote
We can create user-defined server-level roles using the CREATE SERVER ROLE statement only.

a. True
b. False

1 Answer

1 vote

Final answer:

We can create user-defined server-level roles using the CREATE SERVER ROLE statement only is false. In SQL Server, we can create user-defined server-level roles using the CREATE SERVER ROLE statement or the ALTER SERVER ROLE statement.

Step-by-step explanation:

b. False. In Microsoft SQL Server, user-defined server-level roles can be created using both the `CREATE SERVER ROLE` statement and the `sp_addsrvrolemember` stored procedure. While the `CREATE SERVER ROLE` statement is used to create a new server-level role, the `sp_addsrvrolemember` stored procedure is used to add a member to an existing server-level role. Creating and managing server-level roles is essential for controlling access and permissions at the server level. These roles allow database administrators to grant or revoke specific permissions to server-wide operations, providing a flexible and organized way to manage security within a SQL Server environment.

User MystyxMac
by
8.8k points