Logins and users

Hi,
I would like to ask what is the difference between "Login" and "User" entity.
I know that a Login is a principal and I can use it for accessing db
resource, and I can to limit its rights. Why there is a "User" entity also?
Thanks,
LubomirHi Lubomir,
Login is a principal that gains access to the server (to SQL Server
instance). It is generally used for granting permissions on server level
(configuration, database creation and so forth).
User is a principal created in specific database by mapping some single
login to it and is generally used for granting permissions in the database.
Read more in Books Online (SQL Server documentation, also available online).
You should also read about roles (server roles and database roles). Roles
are used for managing permissions in more effective way.
--
Regards
Pawel Potasinski
[http://www.potasinski.pl]
U¿ytkownik "Lubomir" <Lubomir@.discussions.microsoft.com> napisa³ w
wiadomo¶ci news:29BC9649-D34E-4FAE-9855-E8E793AE84E0@.microsoft.com...
> Hi,
> I would like to ask what is the difference between "Login" and "User"
> entity.
> I know that a Login is a principal and I can use it for accessing db
> resource, and I can to limit its rights. Why there is a "User" entity
> also?
> Thanks,
> Lubomir|||At a very basic level, a login is at the server level and
allows connecting to the server.
A user is at the database level and allows access to the
database.
-Sue
On Tue, 7 Aug 2007 11:40:01 -0700, Lubomir
<Lubomir@.discussions.microsoft.com> wrote:
>Hi,
>I would like to ask what is the difference between "Login" and "User" entity.
>I know that a Login is a principal and I can use it for accessing db
>resource, and I can to limit its rights. Why there is a "User" entity also?
>Thanks,
>Lubomir|||Thanks.
"Sue Hoegemeier" wrote:
> At a very basic level, a login is at the server level and
> allows connecting to the server.
> A user is at the database level and allows access to the
> database.
> -Sue
> On Tue, 7 Aug 2007 11:40:01 -0700, Lubomir
> <Lubomir@.discussions.microsoft.com> wrote:
> >Hi,
> >
> >I would like to ask what is the difference between "Login" and "User" entity.
> >
> >I know that a Login is a principal and I can use it for accessing db
> >resource, and I can to limit its rights. Why there is a "User" entity also?
> >
> >Thanks,
> >
> >Lubomir
>