Adaptive Server 15.7 SP100 includes permission changes for commands and functions.
In versions of Adaptive Server earlier than Adaptive Server 15.7 SP100, only users with the sa_role could execute asehostname. For Adaptive Server 15.7 SP100 and later, asehostname has these permission requirements:
With granular permissions enabled, to query the hostname on which the dataserver is running, you must have manage server privileges, or been granted select permission on asehostname.
With granular permissions disabled, you must be a user with sa_role or have select permission on asehostname in order to query the hostname on which the dataserver is running.
A new server level privilege, manage opt goal has been created to enable users with sa_role and sa_serverprivs_role to write or delete goals using sp_optgoal.
With granular permissions enabled, you must be a user with manage opt goal privilege in order to write or delete a goal. By default, sa_role and sa_serverprivs_role are granted the manage opt goal privilege.
With granular permissions disabled, you must be a user with sa_role in order to write or delete a goal.
Any user can run sp_optgoal 'show'.