SQL Server 2012
1) Why does SSMS duplicate Role permission when I add it through a SQL statement?
2) Is it a problem?
If I add permission to a Role in SQL Server through ssms I can find the object and and check the permission (eg grant Insert and Update)
However I have noticed if I add the permission through a SQL statement, I end up with 2 Insert check boxes and 2 Update check boxes.
GRANT Insert ON [dbo].[tbl_Menu_Items] TO [RL_Admin]
GRANT Update ON [dbo].[tbl_Menu_Items] TO [RL_Admin]
Thanks in advance for any help