Logins, Users, and Roles - Getting Started
-
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/awarren/loginsusersandrolesgettingstarted.asp>http://www.sqlservercentral.com/columnists/awarren/loginsusersandrolesgettingstarted.asp
-
Great article, Andy. It's precise and step-by-step. The diagrams help as well. Thanks.
-
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.
-
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
-
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.
-
Couldnt ask for a nicer comment!
Andy
-
Thank you very much, very helpful.
Bruce
-
brillant article -- both the content covered and the way of presenting!
-
Thanks! Hope you'll continue to visit and participate.
Andy
-
Good job. Just what I was looking for to automate login using VB and DMO.
-
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
-
Closest I can think of is sp_addalias, though even that adds a row to sysusers in the db.
Andy
-
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 -
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.
-
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
Viewing 15 posts - 1 through 15 (of 36 total)
You must be logged in to reply to this topic. Login to reply