sp_remoteoption

Description

Displays or changes remote login options.

Syntax

sp_remoteoption [remoteserver [, loginame 
	[, remotename [, optname [, optvalue]]]]]

Parameters

remoteserver

is the name of the server that will be executing RPCs on this server.

NoteThis manual page uses the term “local server” to refer to the server that is executing the remote procedures that are run from a “remote server.”

loginame

is the login name that identifies the local login for the remoteserver, loginame, remotename combination.

remotename

is the remote user name that identifies the remote login for the remoteserver, loginame, remotename combination.

optname

is the name of the option to change. Currently, there is only one option, trusted, which means that the local server accepts remote logins from other servers without user-access verification for the particular remote login. The default is to use password verification. Adaptive Server understands any unique string that is part of the option name. Use quotes around the option name if it includes embedded blanks.

optvalue

is either true or false. true turns the option on, false turns it off.

Examples

Example 1

Displays a list of the remote login options:

sp_remoteoption
Settable remote login options.
remotelogin_option 
------------------------ 
trusted

Example 2

Defines the remote login from the remote server GATEWAY to be trusted; that is, the password is not checked:

sp_remoteoption GATEWAY, churchy, pogo, trusted, true

Example 3

Defines the remote login “pogo” from the remote server GATEWAY as a login that is not trusted; that is, the password is checked:

sp_remoteoption GATEWAY, churchy, pogo, trusted, false

Example 4

Defines all logins from GATEWAY that map to login “albert” on the local server to be trusted:

sp_remoteoption GATEWAY, albert, NULL, trusted, true

Usage

Permissions

Only a System Security Officer can execute sp_remoteoption.

See also

System procedures sp_addremotelogin, sp_dropremotelogin, sp_helpremotelogin

Utility isql