Post reply

Create user

  • March 4, 2010 at 4:00 pm

    #221242

    Hello again.

    I have created a database, and i want to add a user to it.

    In the general tab of User - new, there are three fields im able to type in. User name, Login name, Default schema.

    Im guessing Default schema, is some standard permissions to the new user?

    If user name, is the name of the new user, what do i specify in the login name?

    Thanks in advance.

  • March 5, 2010 at 1:59 am

    #1129033

    LOGIN login_name

    Specifies the SQL Server login for which the database user is being created. login_name must be a valid login in the server. When this SQL Server login enters the database it will acquire the name and ID of the database user that is being created.

    for more description, you can refer these two links:

    CREATE USER

    Creating SQL Server Logins

    Regards,
    Sarabpreet Singh 😎
    Sarabpreet.com
    SQLChamp.com
    Twitter: @Sarab_SQLGeek

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

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