Are there any diagrams on security / permissions?

I am not getting a good handle on the security implementation of SQL Server.
Is there a good diagram that visually shows the relations between the
Server Logins, Database Users and all the possible permissions etc.,
If I read volumes of text about it, I am either not getting the whole
picture or easily forgetting it after a couple of weeks!!
Thanks in advance,
SarahOn Feb 8, 12:07 pm, Sarah Bram <sarahb...@.hotmail.com> wrote:
> I am not getting a good handle on the security implementation of SQL Serve
r.
> Is there a good diagram that visually shows the relations between the
> Server Logins, Database Users and all the possible permissions etc.,
> If I read volumes of text about it, I am either not getting the whole
> picture or easily forgetting it after a couple of weeks!!
> Thanks in advance,
> Sarah
I'm not sure this is really what you want but you could try looking
at ...
http://www.microsoft.com/downloads/...ang=en#Overview
... or ...
http://tinyurl.com/t2u83
... if that's too long. The security views are in the bottom half just
left of centre.

Are there any books about Fuzzy lookup/grouping implementation.

Hello,

I have been experimenting with Fuzzy lookup in SQL2005 for a while, but have lots of questions about its therory and how to customize it. I have read the article on MSDN
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/FzDTSSQL05.asp

and read these 2 articles from Microsoft Research
1) eliminating Fuzzy Duplicates in Data Warehouses by Rohit, Surajit, Venkatesh
2)

are there any books or articles which is more detailed from a implementation/prorgamming perspective..

Please post any thing you may kow.

Thanks,
Saptagiri.Send me an email at Ashvini.Sharma@.microsoft.com and I'll hook you up with the MSR folks.

regards,
ash