When designing a new database I organized the table under different schemas. I've also created a new role that should have select/insert/update/delete rights on one schema and only select on another one. So, using management studio, I went in the first schema properties window, under the permission section I added that role and granted it select/insert/update/delete rights.
Problem is, the next time I went in schema properties window, I did not see the role and the rights I had just assigned. Did it worked? How can I verify?
Best Answer
Instead of relying on SSMS (its flakey sometimes - you might have to refresh, etc), always use T-SQL.
Below script will provide you comprehensive result of what permissions you have set (filter out as per your need)