Add pre- and post scripts on schema deployment

Hi, we're using different schema's to setup security on our data warehouse (one of them is used to contain all objects we use for Reporting Services).  Since we use stored procedures and user defined functions in SSRS we need the option to set execute permissions as well.  Since TimeXtender only sets select permissions, we have to use a post script to set the execute permission, but there isn't an option to do so on schema level.

So, 2 options :

- add the possibility to set execute permissions when setting security on role level

- add pre- and post deploy functionality on all objects (including schema)

Is it possible to add these features ?



Please sign in to leave a comment.