SQL DBA (1/7/2009)
I need differences between Roles, Schemas, Users and Logins. Can anyone help me. Thanks in advance
Have you looked them up on the Books Online? If so, what did you not understand from there?
Here's a bit to get you started:
Login = Server
User = Database
Schema = Object Owner
Role = Security aggregation.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning