Trying to find a good picture/diagram of SQL Server security: logins, roles, etc

and failing miserably.

I was trying to explain this to someone and thought it'd be easier with a nice diagram. Why bother drawing one when you have the web? Alas, I couldn't find anything that was clear enough.

If you have a link to something that clearly shows the boundaries/relationships of how it works, I'd be very grateful

Thanks!

Is this what you're looking for?

http://msdn.microsoft.com/en-us/library/ms191465(v=SQL.90).aspx

That article is available for SQL Server 2005/2008/2008R2/Denali.

I tried posting the image directly, but my rep isn't there yet. :-)

Role-based security in SQL Server http://i.technet.microsoft.com/Cc966453.sp30102%28en-us,TechNet.10%29.gif

Source: SQL Server 2000 Security Model from Microsoft TechNet