LJG
asked on
SQL Server Roles
SQL Server 2012
Question
1) Why does SSMS duplicate Role permission when I add it through a SQL statement?
2) Is it a problem?
Detail
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
LJG
Question
1) Why does SSMS duplicate Role permission when I add it through a SQL statement?
2) Is it a problem?
Detail
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
LJG
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I don't use SSMS GUI interface but I guess that it's using each permission by schema. In your case it's using the default schema (dbo). I guess if you have more schemas it will present more permissions. But this is only a guess, as I said, I don't use SSMS GUI.
ASKER
Thanks so much.
LJG
LJG