Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2006
    Posts
    13

    Unanswered: Login name does not show?

    Hello,

    When I create new Database User the login name input does not show on the list and in the "login name " when checking the Properties of the name. Why this behavior?
    the previous user created a while ago are showing name and login name .
    permissions and rights are the same for between different users having the two different behaviors.

    When I created the new database user I input e.g.:
    Login Name: AD\<<User Name>>
    Name : "First Name"


    Thanks,
    Dom

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Right-click on "Login" in the folders window and select "Refresh". Enterprise Manager is a GUI, and is not always aware of changes to the underlying database.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  3. #3
    Join Date
    Sep 2006
    Posts
    13
    Thanks for the info It helped me discover that the user present in the "Users" container displayed their Login only if they are present in the "Logins" container.

    Does it mean I need to create all Logins before adding Database users?

    Thanks,
    DOm

  4. #4
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    That is the general order of things...

    You should really create your ROLEs first, and grant them appropriate permissions. Then create the logins, grant them access to the database, and assign them to the roles.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •