sp_unbindexeclass

Description

Removes the execution class attribute previously associated with an client application, login, stored procedure, or default execution class for the specified scope.

Syntax

sp_unbindexeclass object_name, object_type, scope

Parameters

object_name

is the name of the application, login, or stored procedure for which you remove the association to the execution class. If the object_type is DF, object_name should be null.

object_type

identifies the type of object_name as AP, LG, PR , or DF for application, login, stored procedure, or default execution class.

scope

is the application name or login name for which the unbinding applies for an application or login. It is the stored procedure owner name (user name) for stored procedures. It is null for object type DF.

Examples

Example 1

Removes the association between “sa” login scoped to application isql and an execution class. “sa” automatically binds itself to another execution class, depending on other binding specifications, precedence, and scoping rules. If no other binding is applicable, the object binds to the default execution class, EC2:

sp_unbindexeclass 'sa', 'lg', 'isql'

Usage

Permissions

The permission checks for sp_unbindexeclass differ based on your granular permissions settings.

Granular permissions enabled

With granular permissions enabled, you must be a user with manage any execution class privilege.

Granular permissions disabled

With granular permissions disabled, you must be a user with sa_role.

Auditing

Values in event and extrainfo columns from the sysaudits table are:

Event

Audit option

Command or access audited

Information in extrainfo

38

exec_procedure

Execution of a procedure

  • Roles – Current active roles

  • Keywords or options – NULL

  • Previous value – NULL

  • Current value – NULL

  • Other information – All input parameters

  • Proxy information – Original login name, if set proxy in effect

See also

System procedures sp_addexeclass, sp_bindexeclass, sp_dropexeclass, sp_showexeclass

Utility isql