Re: Complete Neophyte Question(s)

Disregard, seems my google-ing skills were lacking.

More generic question as I'm messing with the Northwind database to get a
thorough understanding of this. If a user isn't a member of any roles and
has no permissions explicitly defined, does it err on the side of deny or
grant? Or does that depend on the permission? Right now I have a user who
has Connect as the only database level permission, no roles, no secureables
but can still view definition, it seems. I'm able to connect and view all
of the tables, although everything else seems locked down. I have refreshed
and can still see them.

Either way, thanks again. I'm much much further than I was yesterday at
this time.

"James" <minorkeys@xxxxxxxxx> wrote in message
news:uFdBmN%23vHHA.2304@xxxxxxxxxxxxxxxxxxxxxxx
I don't use the word hero very often, but you sir, are the greatest hero of
all time. Thank you for confirming I'm not insane. SP2 has caused the
Securables tab to populate properly and now it actually makes sense.

The only other issue that I'm trying to wrap my head around and can't seem
to google well is the difference between "GRANT" and "WITH GRANT". Can
you enlighten me?

Thank you a million times over!

"Erland Sommarskog" <esquel@xxxxxxxxxxxxx> wrote in message
news:Xns996577CE42B7BYazorman@xxxxxxxxxxxx
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




.