Page 1 of 1

Generate Script ignores 'Script security permissions' setting

Posted: Sat 14 Aug 2021 10:26
by zlenart
1. In the Tools/Generate Script/General tab I have turned on 'Script security permissions' settings.
2. I have enabled this in both groups (Generate Scripts, Generate Scripts As).
3. In Security Manager I have set the Exectute permission for the dbo group on a stored procedure.

What follows is a very interesting phenomenon. The main cript generator (Database/Tasks/Generate Scripts...) function randomly generates grant permission commands or ingores it.
The Generate Scripts As function consequently ignores 'Script security permissions' settings.

This is very important thing, I think it must be some kind of program error, or I don't know something.

Please help mi. Thanks

Re: Generate Script ignores 'Script security permissions' setting

Posted: Thu 19 Aug 2021 10:48
by alexa
Could you please specify for what objects you are performing Database/Tasks/Generate Scripts... ?

Also, please tell us what GRANTs exactly are generated randomly.

In case ,you are attempting to generate GRANTs for system users, dbForge does not allow this.