Blog Pages

SAP (sybase) RS: Permission error while using rs_init

Error message:

Permission denided. You must either be the database/object owner or process any of the following roles in order to perform this operation: sa_role, replication_role
failed to execute 'dbcc is_replication_enabled' as user RS1_RSSD_prim

Solution:
Grant required roles to the relevant users:

use RS1_RSSD
go
grant role sa_role to RS1_RSSD_prim
go
grant role replication_role to RS1_RSSD_prim
go

No comments:

Post a Comment