User's Manual

Chapter 5. A Tutorial for Adaptive Server Enterprise Users
❖ To create the publisher
1. Add a login called hq_user, with hq as the default database and with
system administrator access:
exec sp_addlogin hq_user, hq_pwd, hq
go
exec sp_role ’grant’, sa_role, hq_user
go
2. Add the login name as a user to the HQ database:
use hq
go
exec sp_adduser hq_user
go
3. Make this user the publisher of the HQ database:
exec sp_publisher hq_user
go
Add a remote user Each remote database is identified in the consolidated database by a user ID
with REMOTE permissions. Whether the remote database is a single-user
server or a database server with many users, it needs a single user ID to
represent it to the consolidated database.
In a mobile workgroup setting, remote users may already be users of the
consolidated database, and so no new users would need to be added;
although they would need to be set as remote users.
When a remote user is added to a database, the message system they use and
their address under that message system need to be stored along with their
database user ID.
❖ To create the subscriber
1. If you do not have a login name that you can use for the remote user, add
a login:
exec sp_addlogin field_user, field_pwd, hq
go
2. Add a user to the hq database:
exec sp_adduser field_user
go
3. Grant the user remote permissions. Execute the sp_grant_remote stored
procedure, using field_user as the user name, file as the message type,
and the appropriate directory as the address:
61