SoftTree Technologies Technical Support Forums Register • Search • FAQ • Memberlist • Usergroups • Log in SA 7.1.228 PRO - Sybase edit stored procedure      SoftTree Technologies Forum Index » SQL Assistant View previous topic View next topic SA 7.1.228 PRO - Sybase edit stored procedure Author Message sqltogo Joined: 02 Jul 2014 Posts: 38 Country: Netherlands SA 7.1.228 PRO - Sybase edit stored procedure I am using SQL Editor with a Sybase ASE database. When editing a stored procedure SA generates code for drop and create procedure, this is fine. But I miss the grant statements at the end of the code. When I run just the code in the editor I lose the permissions on the object. Perhaps there is an option to set to get grant statements but I can't find it. Thu Nov 20, 2014 5:08 pm SysOp Site Admin Joined: 26 Nov 2006 Posts: 7948 thank you for reporting this. It should generate the ALTER statement, not sure why it generates DROP and CREATE. I will log this as an issue. Fri Nov 21, 2014 10:06 am Display posts from previous:  All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year  Oldest FirstNewest First     SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours Page 1 of 1   Jump to:  Select a forum ----------------SQL AssistantDB Audit, DB Mail, DB Tools24x7 Scheduler, Event Server, Automation SuiteTips & Snippets Repository You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum     Powered by phpBB © 2001, 2005 phpBB Group Design by Freestyle XL / Flowers Online.