How to update table and column security authorization in dataquery via batch

Discussion created by david.butler on Apr 24, 2019

I am creating a Production clone environment for use by our Development team, one issue I have came across is that I need to be able to change the dataquery authorisation levels for some of our users. I am looking specifically at the table and column security authorisations for our developers. By default they will have Find only access (as per Production access) but I would like update the users access to Update, Erase and Insert. This is to replicate what they would normally have in a Development type environment.

I would like to be able to do this in batch preferably so that I can automate the process for when the clone is rebuilt and also use the same process against other Production clones.


Has anyone came across a method to do this?