Script out object level permissions in procedure editor
a
anonymous
started a topic
over 13 years ago
[This topic is migrated from our old forums. The original author name has been removed] [Attachment has been removed.]
Hi,
We currently do not use the procedure editor for SYBASE v12 because the editor does not script out the procedure permissions along with the CREATE statement. It would be good to have the option to script out these permissions in the editor even if you are doing an alter because you might want to modify the GRANT statements.
This option could be at the specific database level or global. I have attached a screenshot of the options window in SQL Server Query Analyzer where you can enable this option.
Thanks,
Gary
1 Comment
Hans Bergsten
said
over 13 years ago
[This reply is migrated from our old forums.]
Re: Script out object level permissions in procedure editor
Hi,
Thanks for the suggestion. We have improvements for permissions handling in general on our list of things to look at, including dealing with them at Export. I have added your vote for improvements in this area.
Best Regards,
Hans
anonymous
[Attachment has been removed.]