SAP Knowledge Base Article - Preview

2755255 - Error 16367 when an impersonating user tries to execute cross_database stored procedure. - SAP ASE

Symptom

  • An aliased user gets Error 16367 when first trying to run a cross-database stored procedure:

Msg 16367, Level 16, State 1:
Server 'ase157', Procedure 'sp_test', Line 1:
EXECUTE AS OWNER procedures cannot be created by an alias or with the SETUSER command when the procedure has SQL statements that reference objects across databases. Create the procedure from a non-impersonated session.
Msg 11031, Level 16, State 1:
Server 'ase157', Procedure 'sp_test', Line 1:
Execution of procedure sp_test failed because of errors parsing the source text in syscomments during upgrade. Please drop and recreate dbo.sp_test.

  • However, once the sa login gives a first run to this stored procedure, the aliased user can then run it without error.

Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7
  • SAP Adaptive Server Enterprise (ASE) 16.0

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

CR814921, CR#814921, 814921, deferred, resolution, cross_database , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed

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.