Deployment of permissions
as there is no out-of-the-box way of deploying permissions from one system to another, I'm currently trying to achieve this via SQL.
I'm able to add a static SQL script to the package and it will be executed fine on the target system. My problem is that the content of the SQL script is not static. I have to execute an SQL script in the source system to get all the information about the current permission setup and then use these results to build the update/insert statements for the target system.
Did anyone try to accompish this before?
Thanks for any hints!