|
Home > Archive > Microsoft SQL Server forum > April 2006 > Sqlserver Login and user
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Sqlserver Login and user
|
|
| waqarkust@gmail.com 2006-03-29, 8:26 pm |
| 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..
| |
|
| 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 2006-04-02, 7:27 am |
| Jens (Jens@sqlserver2005.de) writes:
> 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.
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@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx
|
|
|
|
|