Skip to main content
SUBMITTED

Automatically deploy table and view security

Related products:TimeXtender Data Integration
  • June 20, 2023
  • 1 reply
  • 37 views

coen.donders
TimeXtender Xpert
Forum|alt.badge.img

Hi,

This is related to post:

The suggested solution is to use 'Review Tasks’ to deploy the changed table/View together with security. But than you have to deselect ALL other tables and views you do not want to deploy/execute. This is not a workable solution when you have hundreds of tables you need to deselect each time you need to deploy a table with security. It is also not directly clear for developers which tables are used in security rules. This would mean that every time you change a table or a view you have to do a differential deployment on data warehouse level.

Please make sure that table/view security is automatically deployed when a table and/or view is changed. Make sure that users don't have to manually add security to the production environment each time after a environment transfer.

1 reply

JTreadwell
Community Manager
Forum|alt.badge.img+5
  • Community Manager
  • September 19, 2024

Hey @coen.donders and @bas.hopstaken,

I’m trying to understand the issue here. I believe that by doing differential deployment of the data warehouse as Matt suggested here, it should pickup the security changes and deploy only the objects required including security. So with this you shouldn’t have to review tasks and click tons of tables. 
 

Have you tried these steps, if so, why does this not solve your problem?