Post reply

Difference between SQL Server Login and Database user

  • February 7, 2011 at 9:23 pm

    #149882

    Hi,

    I am confusing on SQL Server Login and Database user

    Could you clarify this.

    Thanks

  • February 7, 2011 at 9:33 pm

    #1283522

    A login is created on the server level. When this login is mapped to the database, it becomes a user for that particular database.

    Satnam

  • February 9, 2011 at 6:00 pm

    #1284914

    Maybe that could help. That worked with non-IT personel before.

    It is like apartment (Database) in the apartment building (Server).

    Each Apartment Building (Server) has multiple apartments (Databases).

    So in order to get to your apartment you should have door keys from the Building (SQL Server Login) and keys from your apartment ( be a Database user)

    So without SQL Server Login you will not be able to get to your Database: like if you dont have keys from the doors of your building, you will not be able to get to your apartment.

    But if you have only keys from your Building and no keys from your apartment, you pretty much stay in the lobby: If you have SQL Server Login and are not being a Database user, you pretty much limited to master....

  • February 9, 2011 at 7:37 pm

    #1284922

    barsuk (2/9/2011)

    Maybe that could help. That worked with non-IT personel before.

    It is like apartment (Database) in the apartment building (Server).

    Each Apartment Building (Server) has multiple apartments (Databases).

    So in order to get to your apartment you should have door keys from the Building (SQL Server Login) and keys from your apartment ( be a Database user)

    So without SQL Server Login you will not be able to get to your Database: like if you dont have keys from the doors of your building, you will not be able to get to your apartment.

    But if you have only keys from your Building and no keys from your apartment, you pretty much stay in the lobby: If you have SQL Server Login and are not being a Database user, you pretty much limited to master....

    :w00t: good one

  • February 10, 2011 at 12:02 am

    #1284960

    Good one

  • February 10, 2011 at 12:08 am

    #1284964

    Good Information

    Thank you

Viewing 6 posts - 1 through 5 (of 5 total)

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