SAP Knowledge Base Article - Preview

2154500 - Need information about the replication_maint_role_gp system role - SAP ASE 15.7 SP131

Symptom

  • ASE upgraded to 15.7 SP131
  • Need information about the replication_maint_role_gp system role added
  • Set Proxy granted
  • This new role is triggering alarms:

1> sp_helprotect replication_maint_role_gp
2> go
grantor grantee                   type  action                    object column predicate grantable
------- ------------------------- ----- ------------------------- ------ ------ --------- ---------
dbo     replication_maint_role_gp Grant Allow Hadr Login                 All    NULL      FALSE
dbo     replication_maint_role_gp Grant Create Procedure                 All    NULL      FALSE
dbo     replication_maint_role_gp Grant Create Table                     All    NULL      FALSE
dbo     replication_maint_role_gp Grant Delete Any Table                 All    NULL      FALSE
dbo     replication_maint_role_gp Grant Execute Any Function             All    NULL      FALSE
dbo     replication_maint_role_gp Grant Execute Any Procedure            All    NULL      FALSE
dbo     replication_maint_role_gp Grant Identity_insert Any Table        All    NULL      FALSE
dbo     replication_maint_role_gp Grant Identity_update Any Table        All    NULL      FALSE
dbo     replication_maint_role_gp Grant Insert Any Table                 All    NULL      FALSE
dbo     replication_maint_role_gp Grant Manage Replication               All    NULL      FALSE
dbo     replication_maint_role_gp Grant Select Any Table                 All    NULL      FALSE
dbo     replication_maint_role_gp Grant Set Proxy                        All    NULL      FALSE
dbo     replication_maint_role_gp Grant Set Tracing                      All    NULL      FALSE
dbo     replication_maint_role_gp Grant Truncate Any Table               All    NULL      FALSE
dbo     replication_maint_role_gp Grant Update Any Table                 All    NULL      FALSE


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7 SP130 and higher
  • SAP Adaptive Server Enterprise (ASE) 16.0 PL05 and higher

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

hadr_admin_role_gp, HADR, High Availability Disaster Recovery, granular, permission, privilege, DR_admin, maintenance , KBA , hadr_admin_role_gp , replication_maint_role_gp , permissions , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.