Permission Changes for Commands and Functions

Adaptive Server 15.7 SP100 includes permission changes for commands and functions.

Changed Permissions

Configuration parameter Description
asehostname With granular permissions enabled, to query the host name on which the dataserver is running, you must have manage server privileges, or have been granted select permission on asehostname. With granular permissions disabled, you must be a user with sa_role or have select permission on asehostname.
dbcc pravailabletempdbs With granular permissions enabled, you must be a user with manage server privilege to execute pravailabletempdbs. With granular permissions disabled, you must be a user with sa_role.
dbcc serverlimits With granular permissions enabled, you must be a user with manage server privilege to execute serverlimits. With granular permissions disabled, you must be a user with sa_role.
dbcc cis showcaps With granular permissions enabled, you must be a user with manage server privilege to execute cis showcaps. With granular permissions disabled, you must be a user with sa_role.
dbcc cis remcon With granular permissions enabled, you must be a user with manage server privilege to execute cis remcon. With granular permissions disabled, you must be a user with sa_role.
sp_optgoal A new server level privilege, manage opt goal enables users with sa_role and sa_serverprivs_role to write or delete goals using sp_optgoal.