Critical, High, Above Normal, Normal, Below Normal, Low, Background

Normal

Can be set for an individual connection, or for PUBLIC. You must have the SET ANY PUBLIC OPTION system privilege to set this option for PUBLIC or for another user or role. Takes effect immediately.

If you set this option temporarily, the setting applies to the current connection only. Different connections under the same user ID can have different settings for this option.

The value of this option cannot be set higher than the value of the max_priority option.

• max_priority option
• priority connection property
• Tip: Use resource governors