SAP Knowledge Base Article - Preview

3444192 - SQL generated through Data Security Profile replaces "Table Owner Name"  with "USER NAME" string

Symptom

  • SQL generated through Data Security Profile replaces "Table Owner Name"  with "USER NAME" string 
    Eg: <Table Qualifier Name>."USER NAME".<Table NAME>.<OBJECT> 

  • Issue is observed when SQL is generated on universe where Data security profile is added


Read more...

Environment

  • SAP BusinessObjects  Business Intelligence Platform (BI) 4.X
  • Information Design Tool(IDT)
  • UNX 

Product

SAP BusinessObjects Business Intelligence platform 4.3

Keywords

data, security, profile, unx, idt, redshift, amazon, qualifier, owner, table name,user name,sql , KBA , BI-BIP-IDT-DFX , Data Foundation Layer , 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.