Re: Securables for Application Role in Management Studio do not stick

Joginder Nahil (joginder.nahil@xxxxxxxxxxxxxx) writes:
Securables for Application and Database Roles do not show after they have
been setup.
I do the following:

1.. Select an Application Role from Database -> Security -> Roles -
Application Roles and select Properties from the context menu
2.. Select Securables page
3.. Select Add on the Securables panel
4.. Select a couple of objects to add
5.. Check some Explicit permissions for each securable object added
6.. Click on OK
7.. No errors are reported
8.. I repeat steps 1 and 2 above to view the securables that i have > added
9.. Both panles are displayed empty
What am doing wrong?

It seems that your error is simply your expectations. You will first
have to find the objects you want to see permissions for. At least, that appears to be the essence of the resolution of these two bug reports:

http://lab.msdn.microsoft.com/productfeedback/viewfeedback.aspx?feedbackid=cdf6df45-c193-479e-b2af-8e6e4eda1c48
http://lab.msdn.microsoft.com/productfeedback/viewfeedback.aspx?feedbackid=20a86e20-d7ed-4fca-ba7c-2cb6eec4a343

Please don't ask me to defend this behaviour.

--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.

Relevant Pages

  • Re: Viewing Role Permissions for Custom Role
    ... permissions I granted to that role. ... area, but I just ran a test in SP2: I took a role, went to the Securables ... the objects I had granted rights to appeared. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (microsoft.public.sqlserver.security)
  • Re: SQL Server 2005 security question
    ... Harold Shapiro writes: ... when he starts SQL Server Management Studio (logged in with his ... to see which securables PlainVanilla has access to. ... Which version of Mgmt Studio do you have? ...
    (microsoft.public.sqlserver.security)
  • Re: How to view permissions set to database role in Management Studio
    ... Role using the SQL Server Management Studio in SQL 2005? ... On the second page Securables, ... Books Online for SQL Server 2005 at ...
    (microsoft.public.sqlserver.tools)