Symptom
- Any logins running sp_sysmon report error 2849:
Number (2849) Severity (16) State (1) Server (cmx6082) Procedure (sp_sysmon:333) EXECUTE AS OWNER procedures cannot be executed if created by an alias or with the SETUSER command when the procedure has SQL statements that reference objects across databases. Drop and recreate the procedure from a non-impersonated session
- sp_version shows the same version for installmaster as @@version shows for the dataserver binary.
- Re-runnning installmaster as sa does not fix the 2849 error
- sp_helpdb on sybsystemprocs shows the correct owner sa
- sp_help on sp_sysmons shows correct owner as dbo and Object_statas as "execute as owner"
- Running the following query in sysbsystemprocs..sysobjects shows the following for sp_sysmon:
1> select uid, loginame from sysobjects where name = "sp_sysmon"
2> go
uid loginame
1 login1
Read more...
Environment
SAP Adaptive Server Enterprise (ASE) 16.x
Product
Keywords
alias, execute as owner, permission , 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.