It would be beneficial to provide a way within TX to apply permissions for a reporting account to execute a user defined stored procedure.
For one of our customers, there's a need to have Cognos execute a stored proc to bring back a custom reporting structure. Currently I have to create a script and set it to execute after the DWH finishes deploying/executing.
What I'd like to see is an option in TX that allows a user to set this up via the application.
-- Current work path: