The roles required for using sp_configure are as follows:
Any user can execute sp_configure to display information about parameters and their current values.
Only a System Administrator and System Security Officer can execute sp_configure to modify configuration parameters.
Only a System Security Officer can execute sp_configure to modify values for:
