98.7k views
1 vote
ALTER SETTINGS permission grants EXECUTE permission on sp_configure.
A. True
B. False

1 Answer

3 votes

Final answer:

The statement is False because ALTER SETTINGS permission allows changing server-wide options but doesn't implicitly grant EXECUTE permission on sp_configure.

Step-by-step explanation:

The statement ALTER SETTINGS permission grants EXECUTE permission on sp_configure is False. In Microsoft SQL Server, the ALTER SETTINGS server-level permission does allow a user to change server-wide configuration options using the sp_configure stored procedure, but it does not grant EXECUTE permission on sp_configure by default. To execute sp_configure, a user must have the EXECUTE permission explicitly granted or be a member of the sysadmin fixed server role, which inherently has all permissions.

User Marekful
by
7.7k points
Welcome to QAmmunity.org, where you can ask questions and receive answers from other members of our community.