Post reply

user,login

  • July 29, 2009 at 4:02 am

    #132334

    what is the difference between user and login?

  • July 29, 2009 at 4:47 am

    #1031535

    A login exists on the server-level and gives you access to the SQL Server but not necessary to a database.

    A user exists within a database and has access to that database.

    Under normal conditions a user must be linked to a login.

    In SQL 2005/2008 it's possible to create a user without a login. But this is a special case mostly used for service broker communication.

    [font="Verdana"]Markus Bohse[/font]

  • July 29, 2009 at 4:53 am

    #1031538

    thanks a lot.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply