Generate Script ignores 'Script security permissions' setting

Discussion of open issues, suggestions and bugs regarding database management and development tools for SQL Server
Post Reply
zlenart
Posts: 1
Joined: Sat 14 Aug 2021 10:08

Generate Script ignores 'Script security permissions' setting

Post by zlenart » Sat 14 Aug 2021 10:26

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

alexa

Re: Generate Script ignores 'Script security permissions' setting

Post by alexa » Thu 19 Aug 2021 10:48

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.

Post Reply