2154500 - Need information about the replication_maint_role_gp system role - SAP ASE & SRS

• When ASE upgraded to from an older version to a higher version:
• ASE 15.7 SP131 and above
• ASE 16.0 SP02 PL05 and above
• Need information about the replication_maint_role_gp system role that was added and what it does.
• This new role has granted permissions that are not previously seen in previous version.  For example, Set Proxy.
  sp_helprotect replication_maint_role_gp
  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

  
  
• Since, this is a new permission granted, it is raising red flags as to why this is happening.

• SAP Adaptive Server Enterprise (ASE) 15.7 SP130 and higher
• SAP Adaptive Server Enterprise (ASE) 16.0 SP02 PL05 and higher
• SAP Adaptive Server Enterprise (ASE) 16.0 SP03 and higher
• Granular Permissions

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