login with diffrent password

Hi
Is it possible that two databases have same login name user but with
diffrent password'
thanksNo. But it is possible (not recommended) for two different logins to exist
each used by the same individual with different passwords. What problem are
you having?
HTH
Jerry
"perspolis" <rezarms@.hotmail.com> wrote in message
news:%23l9uW8z0FHA.3000@.TK2MSFTNGP12.phx.gbl...
> Hi
> Is it possible that two databases have same login name user but with
> diffrent password'
> thanks
>|||No. What would that accomplish?
What if one of them changed their password, and happened to choose the same
password as the other login? How would you differentiate them then?
A
"perspolis" <rezarms@.hotmail.com> wrote in message
news:%23l9uW8z0FHA.3000@.TK2MSFTNGP12.phx.gbl...
> Hi
> Is it possible that two databases have same login name user but with
> diffrent password'
> thanks
>|||In my application,user can create diffrent databases..
if the login name and password are the same,then a user can login to both of
databases...I don't want this..
I want every user can login his database..
"Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
news:eUM2k#z0FHA.3336@.TK2MSFTNGP12.phx.gbl...
> No. But it is possible (not recommended) for two different logins to
exist
> each used by the same individual with different passwords. What problem
are
> you having?
> HTH
> Jerry
> "perspolis" <rezarms@.hotmail.com> wrote in message
> news:%23l9uW8z0FHA.3000@.TK2MSFTNGP12.phx.gbl...
>|||Logins are not database specific; you can only have a login name appear once
per instance.
Perhaps you are talking about users, not logins. There is a difference.
Please see Books Online.
A
"perspolis" <rezarms@.hotmail.com> wrote in message
news:%233pn1p00FHA.3000@.TK2MSFTNGP12.phx.gbl...
> In my application,user can create diffrent databases..
> if the login name and password are the same,then a user can login to both
> of
> databases...I don't want this..
> I want every user can login his database..|||Well unfortunately that is the way SQL Server's security works. One login -
one password maps to one-to-many databases.
HTH
Jerry
"perspolis" <rezarms@.hotmail.com> wrote in message
news:%233pn1p00FHA.3000@.TK2MSFTNGP12.phx.gbl...
> In my application,user can create diffrent databases..
> if the login name and password are the same,then a user can login to both
> of
> databases...I don't want this..
> I want every user can login his database..
> "Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
> news:eUM2k#z0FHA.3336@.TK2MSFTNGP12.phx.gbl...
> exist
> are
>|||I wrote this a few years back...this will help you undestand SQL Server's
security:
SQL Server 2000 Operations Guide - Security Administration
http://www.microsoft.com/technet/pr...in/sqlops3.mspx
HTH
Jerry
"Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
news:esKPUt00FHA.2428@.tk2msftngp13.phx.gbl...
> Well unfortunately that is the way SQL Server's security works. One
> login - one password maps to one-to-many databases.
> HTH
> Jerry
> "perspolis" <rezarms@.hotmail.com> wrote in message
> news:%233pn1p00FHA.3000@.TK2MSFTNGP12.phx.gbl...
>|||The user could still login to multiple databases, even they did have
multiple logins with different passwords. It is possible using ALTER
DATABASE.. to configure a database to SINGLE_USER mode so that only one user
may login at a time. However, there is no feature to restrict a login to
only one database, unless you drop them as a user or deny permissions to all
databases but one. I would suggest that you steer away from a system design
that allows users to create their own databases, becuase the management
requirements of this design could quickly get out of hand.
"perspolis" <rezarms@.hotmail.com> wrote in message
news:%233pn1p00FHA.3000@.TK2MSFTNGP12.phx.gbl...
> In my application,user can create diffrent databases..
> if the login name and password are the same,then a user can login to both
> of
> databases...I don't want this..
> I want every user can login his database..
> "Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
> news:eUM2k#z0FHA.3336@.TK2MSFTNGP12.phx.gbl...
> exist
> are
>|||I know what user does..the question is that you can login to many database
with one login name and password..
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:OSfXer00FHA.3568@.TK2MSFTNGP15.phx.gbl...
> Logins are not database specific; you can only have a login name appear
once
> per instance.
> Perhaps you are talking about users, not logins. There is a difference.
> Please see Books Online.
> A
>
> "perspolis" <rezarms@.hotmail.com> wrote in message
> news:%233pn1p00FHA.3000@.TK2MSFTNGP12.phx.gbl...
both
>|||thanks all for their replying.
If I use application role,I think I can manage the problem..
what's your opinion'
"Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
news:eUM2k#z0FHA.3336@.TK2MSFTNGP12.phx.gbl...
> No. But it is possible (not recommended) for two different logins to
exist
> each used by the same individual with different passwords. What problem
are
> you having?
> HTH
> Jerry
> "perspolis" <rezarms@.hotmail.com> wrote in message
> news:%23l9uW8z0FHA.3000@.TK2MSFTNGP12.phx.gbl...
>