sp_msgadmin 'default'

Description

Specifies a default login and password for the specified message provider.

Syntax

 sp_msgadmin ’default’, ’login’, provider_name, 
    provider_login, provider_password

Parameters

‘default’

Specifies a default.

‘login’

Specifies a default login.

provider_name

The name of the messaging provider to remove, or the name of the message provideer from which the specified login is removed.This can be as many as 30 characters long.

provider_login

The login the provider uses as the default login when sending or receiving messages from the messaging provider specified by provider_name.

provider_password

The password used for the provider_login.

Examples

Example 1

Specifies the default login that applies to all unmapped Adaptive Server logins, when using a specified messaging provider for either sending or receiving. You must first register the provider_name by calling sp_msgadmin 'register', 'provider'.

sp_msgadmin ’default’, ’login’, ’my_jms_provider’,
     ’jms_user1’, ’jms_user1_password’

Usage

• You can check the default login by entering:

  sp_msgadmin ’list’, ’login’, ’my_jms_provider’
  

• You can remove the default login by entering’

  sp_msgadmin ’remove’, ’login’, ’my_jms_provider'
  

See sp_msgadmin for usage common to the variants of sp_msgadmin.

Permissions

You must have messaging_role and sso_role permissions to issue sp_msgadmin ’default’.

Copyright © 2004. Sybase Inc. All rights reserved.

View this book as PDF