SAP Knowledge Base Article - Preview

1988548 - 10330 permission error using dynamic sql in a stored procedure - SAP ASE

Symptom

  • 10330 error when exeuting a stored procedure that updates a user table. 
  • The error returned from the exeution is:

1> exec p2
2> go
Msg 10330, Level 14, State 1:
Server 'ASE138', Procedure 'p2', Line 4:
EXECUTE permission denied on object p2, database master, owner dbo
(return status = -4)


Read more...

Environment

  • Adaptive Server Enterprise (ASE) 15.7
  • Dataserver

Product

SAP Adaptive Server Enterprise 15.7

Keywords

10330 permission denied , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem

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.