How to resolve the error 'Select permission denied on column' when working with Column Based Security in TIBCO Data Virtualization?

How to resolve the error 'Select permission denied on column' when working with Column Based Security in TIBCO Data Virtualization?

book

Article ID: KB0072780

calendar_today

Updated On:

Products Versions
TIBCO Data Virtualization All supported versions

Description

This article states the steps to resolve the error 'Select permission denied on column' when working with Column Based Security (CBS) in TIBCO Data Virtualization (TDV).

Example use-case: 

- Enabled CBS for the 'phonenumber' column on a view 'test.video_test' for a user and publish it in TDV.
- When accessing the published view from SQL Workbench, the below error is observed:

An error occurred when executing the SQL command:
SELECT *
FROM test.video_test

An exception occurred when executing the following query: "SELECT * FROM test.video_test". 
Cause: Select permission denied on column 'phonenumber'.  On line 1, column 8.  [parser-2900510] [Log ID: 6d5512b0-fd0c-4b9b-bb45-2ec11ff08c49] [jdbc-1906510] [DB Errorcode=1906510]
1 statement failed.
Execution time: 0.01s

 

 

Issue/Introduction

How to resolve the error 'Select permission denied on column' when working with Column Based Security in TIBCO Data Virtualization?

Resolution

1. From the Studio main menu, select Administration > Configuration.
2. In the Configuration window, navigate to Server > Configuration > Security > Enable Exception For Column Permission Deny.
3. Set this parameter to false
4. Test the view from the client interface

Powered by Wolken Software