sp_optgoal

Adaptive Server Enterprise version 15.7 SP100 changes permission checks for sp_optgoal based on your granular permissions settings.

When granular permissions is:

Enabled – you must be a user with manage opt goal to create or delete a goal.
Disabled – you must be a user with sa_role to create or delete a goal

Any user can run sp_optgoal show.

Once a goal is created, all users can use the goal.

Parent topic: Changed System Procedures

Related concepts

Permission Changes for Commands and Functions

Created July 29, 2013. Send feedback on this help topic to Technical Publications: pubs@sybase.com