During development (especially during the user test) you sometimes have to make quick changes to functionality. However executing the code from the functionality - result screen will do a drop and create, messing up any rights set to the procedure. It would be very helpful if instead the code did a if exists alter , if not exists create. Since this is probably not wanted since some people use the result screen to edit their code I would also be happy if there was a second button (generate as alter procedure). This way any rights set to the object will remain intact. This would save a lot of time during user tests and would decrease the change of errors due to overwriting the current procedure.
Login to the Thinkwise Software Community
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.