Script for procedures - add grants to the script?


When opening a procedure from object explorer and viewing the script or opening it in editor as script it does not include the grants.

A useful feature when opening the script for editing or execution is to include the grants as separate statements at the end of the script. The permissions are listed in the viewer so it should be possible to generate the statements needed to recreate them - assuming the user is the same as the grantor?

It would be very useful as I have discovered the hard way a couple of times that I use the explorer viewer to generate the script make some changes and execute it only to have my test fail because I forgot to add the grants at the end.

Kjartan M-S

Hello Kjartan M-S,

We currently have this enhancement request scheduled for the next version under CR 95,204.




Kjartan M-S