SAP Knowledge Base Article - Preview

1973263 - Wrong suid in sysprocesses when execute store procedure with execute as owner from a other database context - SAP ASE

Symptom

Wrong suid in sysprocesses when execute store procedure with execute as owner from a other database context.

use master
go
exec tempdb..base_rpc_eao_timeinterval '00:01:00'
go


1> select spid, suid, program_name, status, cmd, dbid, uid
2> from master..sysprocesses
3> where cmd='WAITFOR'
4> go
 spid   suid        program_name                   status       cmd                            dbid   uid
 ------ ----------- ------------------------------ ------------ ------------------------------ ------ -----------
     35           5 isql                           alarm sleep  WAITFOR                             2           1

(1 row affected)
1>

use tempdb
go
exec tempdb..base_rpc_eao_timeinterval '00:01:00'
go


1> select spid, suid, program_name, status, cmd, dbid, uid
2> from master..sysprocesses
3> where cmd='WAITFOR'
4> go
 spid   suid        program_name                   status       cmd                            dbid   uid
 ------ ----------- ------------------------------ ------------ ------------------------------ ------ -----------
     35           1 isql                           alarm sleep  WAITFOR                             2           1

(1 row affected)
1>


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 15.7 and above

Product

SAP Adaptive Server Enterprise 15.7

Keywords

suid, sysprocesses , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , SAP Business Suite on Sybase ASE Database Platform , 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.