Displays or changes remote login options.
sp_remoteoption [remoteserver[, loginame [, remotename[, optname[, optvalue]]]]]
is the name of the server that will be executing RPCs on this server.
This 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.”
is the login name that identifies the local login for the remoteserver, loginame, remotename combination.
is the remote user name that identifies the remote login for the remoteserver, loginame, remotename combination.
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.
is either true or false. true turns the option on, false turns it off.
Displays a list of the remote login options:
sp_remoteoption
Settable remote login options. remotelogin_option ------------------------ trusted
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
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
Defines all logins from GATEWAY that map to login “albert” on the local server to be trusted:
sp_remoteoption GATEWAY, albert, NULL, trusted, true
To display a list of the remote login options, execute sp_remoteoption with no parameters.
If you have used sp_addremotelogin to map all users from a remote server to the same local name, specify trusted for those users. For example, if all users from server GOODSRV that are mapped to “albert” are trusted, specify:
sp_remoteoption GOODSRV, albert, NULL, trusted, true
If the logins are not specified as trusted, they cannot execute RPCs on the local server unless they specify local server passwords when they log into the remote server. When they use Open Client Client-Library, users can specify a password for server-to-server connections with the routine ct_remote_pwd. isql and bcp do not permit users to specify a password for RPC connections.
If users are logged into the remote server using “unified login”, the logins must also be trusted on the local server, or they must specify passwords for the server when they log into the remote server.
See the System Administration Guide for more information about setting up servers for remote procedure calls and for using “unified login.”
The permission checks for sp_remoteoption differ based on your granular permissions settings.
Granular permissions enabled |
With granular permissions enabled, you must be a user with manage any remote login privilege. |
Granular permissions disabled |
With granular permissions disabled, you must be a user with sso_role. |
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 |
|
System procedures sp_addremotelogin, sp_dropremotelogin, sp_helpremotelogin
