Re: Complete Neophyte Question(s)

James (minorkeys@xxxxxxxxx) writes:
Thank you very much. I believe I have my head wrapped around this better.

When I go to the Securables tab for this role, there are no objects in the
listbox. Simply an Add button. Yet, if I view the properties of certain
stored procedures it will have that role listed with execute permissions.

This seems like a simple request, but all I want is to see the objects
that a certain role has permissions on, and what those permissions are?
Rhetorical: Why is this so difficult/counter-intuitive?

I did some research, and I think I have the answer. If you do Help->About
what version do you get for Managment Studio? My guess is that you will
see something 9.00.1399 or 9.00.2047, that is either RTM or SP1. To wit,
when I try this on SP1 of SSMS, I don't see the securables, but SP2 gives
me the list of objects.

You can find the latest service pack for SQL Server on
http://support.microsoft.com/kb/913089/.



--
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
.