Sqlserver Login and user

[waqarkust@gmail.com]

What is the diffrence between Sql Server Login and Sql server Database
User?
I want to put a funtionality in my application from where administartor
make Application User.
these application user will be made also in sqlserver..
Now I am confuse here In sqlserver Login and User
Well I will make both for A new user of my application Sqlserver Login
and Sql server user,
Plz help me What to do with It..

[Jens]

Re: Sqlserver Login and user

Hi,

SQL Server login controls the login to the server and does the
authentication of the users and the autorization on server level (e.g.
for server roles). The database logins and mapped users are for
authorization within the database. YOu need to first have a user
created on server level and grant him permissions to connect to the
server to authorize him in the database.

HTH, Jens Suessmeyer.

---

http://www.sqlserver2005.de

---

[Erland Sommarskog]

Re: Sqlserver Login and user

Jens (Jens@sqlserver 2005.de) writes:[color=blue]
> SQL Server login controls the login to the server and does the
> authentication of the users and the autorization on server level (e.g.
> for server roles). The database logins and mapped users are for
> authorization within the database. YOu need to first have a user
> created on server level and grant him permissions to connect to the
> server to authorize him in the database.[/color]

In SQL 2005, you can create database users that does not have logins.
This is useful in a couple of situations. One is when you use certificates
or EXECUTE AS to create a customer permissions. Another is when the
application authenticates the users outside SQL Server and logs into
SQL Server with the same login for all user. The application can then
do EXECUTE AS on the database users, so once there it works like a normal
application. But since the users are locked out from SQL Server, they
can do no harm if they get query tool in their hands.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se

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