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]

SQL Roles Issue
Thanks in advance for any help
LJG
LVL 2
LJGAsked:
Who is Participating?
 
Pawan KumarDatabase ExpertCommented:
1) Why does SSMS duplicate Role permission when I add it through a SQL statement?
It may be a way SSMS shows the things. Also Did u check whether Insert/update without dbo are already there or not ?

>> 2) Is it a problem?
NO
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
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.
0
 
LJGAuthor Commented:
Thanks so much.
LJG
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.