You can translate the question and the replies:

Bring rules of the tables to base views

we have implemented security on tables in sql server ...we are using denodo 7.0.when we import the tables to create the base view do they bring them all or do we need to recreate them all again in denodo ? the denodo security doc dont have any comments on this
user
11-02-2021 12:06:52 -0500

1 Answer

Hi, For your scenario, I would create a [JDBC data source](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/creating_data_sources_and_base_views/jdbc_sources/jdbc_sources) using “**pass-through session credentials**” as an authentication type in Virtual DataPort Server. This allows Virtual DataPort to connect to SQL Server using the credentials of the user that executes the query. Then, I would make sure to [create users](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/databases_users_and_access_rights_in_virtual_dataport/administration_of_databases_users_roles_and_their_access_rights/creating_users#creating-users) with the same credentials of the data source by navigating to the ‘**Administration > User Management**’ tab in Virtual DataPort Administration Tool. For example, lets say a user “test_user” executes a query selecting the column which is restricted in MS SQL Server like “SELECT <data_source_restricted_field> FROM view_name” in VQL Shell. During the execution, Virtual DataPort server will pass the session credentials to the data source which will apply the defined restrictions and then, will execute or throw permission exception accordingly. You can take a look at the [Considerations When Configuring Data Sources with Pass-Through Credentials](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/appendix/considerations_when_configuring_data_sources_with_pass-through_credentials/considerations_when_configuring_data_sources_with_pass-through_credentials) section of Virtual DataPort Administration Guide for more information. Hope this helps!
Denodo Team
12-02-2021 03:48:37 -0500
You must sign in to add an answer. If you do not have an account, you can register here