Hi Team,
In SQL Enterprise Manager, when we expand "Database -->Users", we see the
users there. When we expand "Security --> logins" we see the same users there.
Can you differentiate these two.
Thanks
Santhosh
Logins are the accounts used to connect to the SQL Server, users are the accounts used within individual databases. So it is possible (not very useful, but possible) to have a login so that you can connect to the server but not be able to actually do anything in any databases. Each login must be mapped to a user in each database that the login needs to use.
Permissions in a database are assigned to users not to logins.
You should read up more on users, logins, and permissions in Books Online.
