SAP Knowledge Base Article - Preview

3020868 - Msg 10331 Permission denied because lack of SET PROXY permission - SRS

Symptom

  • Execute sp_recompile @objname='dbo.table' in a Warm Standby (WS) or MSA replication system.
  • DSI EXEC starts getting the following permission errors after upgraded to SRS 16.0 SP04:
    • ERROR #13040 DSI EXEC(141(1) SDS.SDB) - neric/useful/cmapp.c(709)
              Failed to set a property in the connection structure for a connection handle. See Connector error message for more information.

    • ERROR #1028 DSI EXEC(141(1) SDS.SDB) - neric/useful/cmapp.c(709)
             Message from server: Message: 10331, State 2, Severity 14 -- 'Permission denied, database master, owner dbo. You need the following permission(s) to run this command: SET PROXY.                                                                   


Read more...

Environment

SAP Replication Server (SRS) 16.0 SP04 and up

Product

SAP Replication Server 16.0

Keywords

dsi_replication_ddl; dsi_replication; , KBA , BC-SYB-REP , Sybase Replication Server (standalone) , Product Enhancement

About this page

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

Search for additional results

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