Logins, Users, and Roles - Getting Started

  • Andy Warren

    SSC Guru

    Points: 119676

  • mshapiro

    Valued Member

    Points: 69

    Great article, Andy. It's precise and step-by-step. The diagrams help as well. Thanks.

  • jamyer

    Default port

    Points: 1403

    Good overview!

    Now about that "free" product Microsoft calls "Enterprise" Manager or EM. It stinks. Especially as your users on a server increase and the number of servers you manage grow.

    EM has a lot of short comings. I would prefer to call it Workgroup Manager or something not so lofty as "Enterprise" Manager. Just buying a third party product to replace EM is one solution, but if you work in a large shop you still end up having to support EM, the "free" tool.

  • Andy Warren

    SSC Guru

    Points: 119676

    Mshapiro - thanks for the comment and very glad you found it helpful. I'll probably tackle a different part of DMO next month, fun to explore.

    I'll admit EM is a bit heavy at times. I use it, haven't seen the need so far to look at a replacement...and might have to build my own anyway! ISQLW is a good complement to it in SQL2K, object browser seems fast compared to EM.

    Andy

  • mbabb

    Newbie

    Points: 9

    I am an old man who is struggling to grasp the rudiments of SQL Server.

    Thank you for the lucid article. I printed it and intend to follow it step by step.

    Also, thank you for considering the needs of beginners. I use BOL regularly, but your article was vastly superior to BOL.

    Not everyone grew up with a keyboard.

  • Andy Warren

    SSC Guru

    Points: 119676

    Couldnt ask for a nicer comment!

    Andy

  • BRP

    Ten Centuries

    Points: 1273

    Thank you very much, very helpful.

    Bruce

  • dengyuan

    Grasshopper

    Points: 13

    brillant article -- both the content covered and the way of presenting!

  • Andy Warren

    SSC Guru

    Points: 119676

    Thanks! Hope you'll continue to visit and participate.

    Andy

  • eletuw

    SSCrazy

    Points: 2464

    Good job. Just what I was looking for to automate login using VB and DMO.

  • abhi_develops

    Say Hey Kid

    Points: 676

    Hi Andy,

    That was a good article.

    I think most experienced SQL Developers are aware of the difference

    between "logins" and "users".

    However developers new to this area may not be aware. I had faced a similar problem with SQL Server 7.0 in 1999, when I came to know of this difference.

    However I am not yet totally convinced about the need to add a user, when you already have a login.

    Couldn't you simply grant access to the "loginid" created?

    Cheers!

    Abhijit

    Edited by - abhi_develops on 02/16/2003 9:51:27 PM

  • Andy Warren

    SSC Guru

    Points: 119676

    Closest I can think of is sp_addalias, though even that adds a row to sysusers in the db.

    Andy

    http://www.sqlservercentral.com/columnists/awarren/

  • dronator2k

    SSC Enthusiast

    Points: 190

    Excellent article. I really enjoyed the examples that we can use as a template to base our own scripts according to the needs of our organization.

    On a side note, I must say that ya'll have one of the best SQL resource sites on the web. The quality is top-notch and both experts and beginners can find something that will help them. Thanks for all of the effort!


    Adrian Porter

  • rolandvon

    SSC Enthusiast

    Points: 139

    THANK YOU. That short, concise article is EXACTLY what I was looking for to clear out the difference between Logins and Users in MY HEAD.

    Thanks a lot, great article.

  • Andy Warren

    SSC Guru

    Points: 119676

    Thanks for the comments, and the compliments! We try to keep a good mix of content so that as readers grow and learn, there's always something more there.

    Andy

    http://www.sqlservercentral.com/columnists/awarren/

Viewing 15 posts - 1 through 15 (of 37 total)

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