[Fixed] SSMS – Create script duplicates the statements for Grant or Deny Column Permissions…

I was reported a bug in Microsoft SQL Server (all versions) that related to generate script for database permissions on August 20, 2013.

Steps to Reproduce

Open SSMS >> Connect to Server >> In Object Explorer expand a Sample Database >> expand Security >> right click on Users >> click on New User… >> Fill needed data in General section >> click on Securables >> click on Search >> select a table and add it… >>
In Permission window in Explicit >> click on Select or Update >> Then click on Column Permission >> select Grant to one column and click OK
Now If click on Script to generate its script, you can see the statements to grant or deny are duplicated in produced script.

Expected Results

non- duplicate
I’m happy to see that Microsoft fixed it soon on October 17, 2013. And the change will be included in a future release or servicing release for SQL Server. For more info please visit this link:
So, may need to install latest update!

Leave a comment

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s