sp_deletesmobj

(Only when the TSM is licensed at your site) Deletes specified backup objects from the IBM Tivoli Storage Manager (TSM).

Syntax

sp_deletesmob “syb_tsm“, “server_name"{, “database_name”, “object_type”, “dump_type", “until_time", “bs_name"}

Parameters

Examples

Usage

See also Using Backup Server with IBM Tivoli Storage Manager.

Permissions

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

SettingDescription
Enabled

With granular permissions enabled, you must be a user with dump any database privilege.

Disabled

With granular permissions disabled, you must be a user with sa_role or oper_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_querysmobj