By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,419 Members | 1,636 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,419 IT Pros & Developers. It's quick & easy.

Sqlserver Login and user

P: n/a
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..

Mar 30 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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
---

Mar 30 '06 #2

P: n/a
Jens (Je**@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, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

Apr 2 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.