Generate Script ignores 'Script security permissions' setting
Posted: 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
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