Execute permissions

Vinny

Member²
Is it possible to enhance the package (specification) editor to include a tab that displays permissions? And then upon save have those grants included in the resulting file? Maybe this functionality exists already? Also, upon load of that file, would it be possible to convert that grant information back into the appropriate UI display? I like having the grant with the specification so that when the file is "installed" into production all the appropriate information is in one file.

Is there a better way to do this?
 
Can you also add to the enhancement list an option to include the owner of a program unit upon file save? If I open a package for edit from the browser and save, it will not include the owner if I am logged in as that user. Only if I edit another user's code does the user get appended (i.e. CREATE OR REPLACE user.package_name vs. CREATE OR REPLACE package_name)
 
Back
Top