You can translate the question and the replies:

COLUMNS RESTRICTION DONT WORK

Hi, I have an issue with the column privileges, whenever i try to put a restriction on column, i get an error over the view and i can't see any data. The rows restrictions worls perfectly. I use denodo 8. Thanks
Security
user
02-05-2023 08:54:40 -0400
code

1 Answer

Hi, I tried querying a whole view with a user that had column restricions on that view and also received an error. Note that this is the expected behaviour though. What works is to only select the columns your user has access rights to. So you have to exclude the columns for which your user does not have priviliges to access them. Let's suppose I do not have priviliges to the column "credit_card" of a view "customer". In this case the query **SELECT name, credit_card FROM customer** will throw an error. For the query to work correctly I am only allowed to select the columns I have access to such as: **SELECT name FROM customer ** (assuming I have access to "name"). I have found information about the topic in the section [Fine-Grained Privileges at View Level](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/databases_users_and_access_rights_in_virtual_dataport/fine_grain_view_privileges/fine_grain_view_privileges#column-privileges) of the Virtual DataPort Administration Guide. Hope this Helps!
Denodo Team
03-05-2023 06:01:15 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here