2113772 - SQL stmts with/without prefix give different results - SAP ASE | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2113772 - SQL stmts with/without prefix give different results - SAP ASE

Symptom

  • A table is created by sa/dbo.
  • A user is granted update permission on the table.
  • Executing the following queries give different results: 

Query 1: update test set col1=t.col1 from test t where t.col2='row10'
Query 2: update pubs2.dbo.test set col1=t.col1 from pubs2.dbo.test t where t.col2='row10'
Query 3: update test set col1=t.col1 from pubs2.dbo.test t where t.col2='row10'


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) all versions

Product

SAP Adaptive Server Enterprise all versions ; Sybase Adaptive Server Enterprise all versions

Keywords

database, owner, select, update, insert, delete, statement , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , SAP Business Suite on Sybase ASE Database Platform , How To

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.