Permissions for set commands

The sa_role has full access to the set commands described above.

For other users, new set tracing permissions must be granted and revoked by the System Administrator to allow set option and set plan for XML, as well as dbcc traceon/off (3604,3605).

For more information, see the grant command description in Adaptive Server Reference Manual: Commands.