SAP Knowledge Base Article - Preview

3020868 - Msg 10331 Permission denied because lack of SET PROXY permissions in WS. -SRS

Symptom

  • Execute sp_recompile @objname='dbo.table' in a Warmstandby(WS) replication system.
  • DSI EXEC starts getting the following permission errors after upgraded to SRS160SP04 :
    • 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

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 ONE Support launchpad (Login required).

Search for additional results

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