sp_drop_resource_limit

Removes one or more resource limits from the SAP ASE server.

Syntax

sp_drop_resource_limit { name, appname }
	[, rangename, limittype, enforced, action, scope]

Parameters

Examples

Usage

To determine which resource limits apply to a given user, application, or time of day, use sp_help_resource_limit.

When you use drop login to drop an SAP ASE login, all resource limits associated with that login are also dropped.

The deletion of a resource limit causes the limits for each session for that login and/or application to be rebound at the beginning of the next query batch for that session.

See the System Administration Guide for more information on resource limits.

Permissions

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

SettingDescription
Enabled

With granular permissions enabled, you must be a user with manage resource limit privilege.

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:

InformationValues
Event

38

Audit option

exec_procedure

Command or access audited

Execution of a procedure

Information in extrainfo
  • 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

Related reference
sp_add_resource_limit
sp_droplogin
sp_help_resource_limit
sp_modify_resource_limit