The present disclosure provides a method and automation system for role automation for data virtualization. When user modifies/builds views, the automation system defines available security role master, row-level security rules, column-level security rules and view-specific security rules. The automation system then creates base view for master and obtains existing permission from metadata. The automation system compares results of base review and existing permission to find if there is any change in security rule. The automation system creates generic framework to generate security scripts in VQL to modify roles and store results into database as table. The automation system creates procedures to call VQLs and deploy in VQL shell. Thereafter, automation system schedule procedures using scheduler to run periodically, to verify and update security after each change in database. Thus, the present disclosure reduces time consumption for updating roles by automating the process.

Creative Commons License

Creative Commons License
This work is licensed under a Creative Commons Attribution 4.0 License.