SQL Remote User's Guide
SQL Remote Administration
Managing SQL Remote permissions
Granting and revoking REMOTE and CONSOLIDATE permissions
Each remote database must be represented by a single user ID in the consolidated database. This user ID must be granted REMOTE permissions to identify their user ID and address as a subscriber to publications.
Granting REMOTE permissions accomplishes several tasks:
It identifies a user ID as a remote user.
It specifies a message type to use for exchanging messages with this user ID.
It provides an address to where messages are to be sent.
It indicates how often messages should be sent to the remote user.
Granting REMOTE permissions is also referred to as adding a remote user to the database.
You can add a remote user to a database using Sybase Central. Remote users and groups appear in two locations in Sybase Central: in the Users & Groups folder, and in the SQL Remote Users folder. This section applies only to Adaptive Server Anywhere databases.
By default, remote users are created with remote DBA authority. Since the message agent for access to the remote database requires this authority, you shouldn't revoke it.
You cannot create a new remote user until at least one message type is defined in the database.
While you can grant remote permissions to a group, those remote permissions do not automatically apply to users in the group (unlike table permissions, for example). To do this, you must explicitly grant remote permissions to each user in the group. Otherwise, remote groups behave exactly like remote users (and are categorized as remote users).
To add a new user to the database as a remote user (Sybase Central)
In the left pane, select the SQL Remote Users folder.
From the File menu, choose New
The Create a New Remote User wizard appears.
Follow the instructions in the wizard.
To make an existing user remote (Sybase Central)
Open the Users & Groups folder.
Right-click the user you want to make remote and choose Change to Remote User from the popup menu.
In the resulting dialog, select the message type from the list, enter an address, choose the frequency of sending messages, and click OK to make the user a remote user.
This user now appears in both the Users & Groups folder and the SQL Remote Users folder.
The following statement grants remote permissions to user S_Beaulieu, with the following options:
Use an SMTP e-mail system
Send messages to e-mail address s_beaulieu@acme.com:
Send message daily, at 10 p.m.
GRANT REMOTE TO S_Beaulieu TYPE smtp ADDRESS 's_beaulieu@acme.com' SEND AT '22:00'
The following statement grants remote permissions to user S_Beaulieu with the following options:
Use the file-sharing system to exchange messages.
Place messages in the directory beaulieu under the address root directory.
The address root directory (for both Adaptive Server Anywhere and Adaptive Server Enterprise) is indicated by the SQLREMOTE environment variable, if it is set. Alternatively, it is indicated by the Directory setting in the FILE message control parameters (held in the registry or INI file).
Send messages every twelve hours:
exec sp_grant_remote 'S_Beaulieu', 'file', 'beaulieu', 'SEND EVERY', '12:00' go