Sybase DC38133-01-0902-01 manual To create the publisher, To create the subscriber

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