Permissions for set commands

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

For other users, the system administrator must grant and revoke new set tracing permissions 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.