Limiting SQL access to selected columns in a Datacom table

Products

• Datacom
• Datacom/DB

Issue/Introduction

With a Datacom table enabled for SQL use, can access to individual columns in that table be limited?

Erasing or blanking out the SQLNAMEs for these fields or columns in the Test version of the definition showed the column names restored when it was promoted to Prod.

 

 

 

Resolution

To grant or restrict SQL access to selected fields (columns) in a Datacom table, create an SQL VIEW against the Table and then include only those columns you want to be available. For more information on working with SQL Views, please review the Datacom documentation Sample Data Description Language topic "Views."

According to the documentation section SQL Names for FIELD Occurrences, "If you do not specify the SQL name for the FIELD occurrences that are defined to a table that has AUTHID, SQLNAME, and SQL-INTENT attribute-values assigned, Datacom Datadictionary creates the SQL names during execution of the SET DATABASE function."

 

Additional Information

As always, please contact Broadcom support for Datacom if you have further questions.