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

Hi Erland,

Thanks for pointing me to the bugs and a speedy response.

In my book they are definite bugs. I somehow find it hard it accept that the
behaviour is 'as designed'. I have shown this behaviour to a number of SQL
Server expert users who all thought that the behaviour is unacceptable and
should be treated as bugs. I have not got the energy to fight the case.

Regards,
Joginder Nahil
www.starprint2000.com


"Erland Sommarskog" <esquel@xxxxxxxxxxxxx> wrote in message
news:Xns977EF009D59FBYazorman@xxxxxxxxxxxx
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: Securables for Application Role in Management Studio do not stick
    ... In my book they are definite bugs. ... But it's still a very poor GUI design. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (microsoft.public.sqlserver.tools)
  • Re: DTV antennas?
    ... As there are different individuals, and they write different books, in ... seems that features and functions is what sells products. ... is added, so are bugs. ... Would you consider these people to be in the "learning impairment" ...
    (sci.electronics.design)
  • Re: Schildt
    ... thanked me for fixing his wikipedia biography) to join us, ... Books don't have bugs: software does. ...
    (comp.lang.c)
  • Re: Large varchar columns with SQL server
    ... I'm trying to track down some bugs that I read about at ... I'm connecting to a SQL ... these issues with SQL Server 7 via ODBC using ADO 2.1 with MDAC 2.1. ...
    (microsoft.public.data.ado)
  • Re: Project with common errors of the designers
    ... Very good idea about looking through the papers with bugs taxonomy!!! ... Books such as ... The book COMPREHENSIVE FUNCTIONAL VERIFICATION: ...
    (comp.lang.verilog)