You may need to upgrade a database to work with the latest version of Replication Server so that you can use newer features. Use rs_init to upgrade a database.
Upgrading a database ensures that the database maintenance user has the Replication role and the necessary permissions (update, insert, and delete) in the database. The Replication role gives the maintenance user authorization to execute any necessary replication-related Adaptive Server commands.
You can check the authorizations that have been granted to a database by using the sp_displaylogin system procedure in the database.
To grant the Replication role to the maintenance user, execute the following system procedure in the database:
sp_role "grant", replication_role, maintenance_user
If you need to grant permissions on the tables in the database, execute the following command in the database for each table:
grant all on table_name to maintenance_user
