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 , Business Suite on Adaptive Server Enterprise , How To

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.