If
you enable granular permissions for Adaptive Server and then use
rs_init to upgrade Adaptive Server user databases,
rs_init attempts to grant the
replication_role permission to the user ID that you used to
execute
rs_init and also to the maintenance user ID for the user
databases. However,
rs_init fails to grant the
replication_role permission because since
dbo,
the master database owner, does not have have the
manage roles
permission, and you see an error message such
as:
SQL Server message: msg 10331, level 14, state 2
WARNING: "Permission denied, database master, owner dbo.
You need the following permission(s) to run this command: MANAGE ROLES."
Ignore
the error message and press the Enter key to continue because the user database
upgrade can still proceed.