InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 19 May 2013 12:28:14 GMT20http://www.sqlservercentral.com/Forums/Topic129731-32-1.aspxSteve, excellent post on logins/users! Do you have an updated 2005/2008 version of this? Any help would be greatly appreciated. Thanks!SharmaThu, 04 Feb 2010 19:44:46 GMTSQLSharmahttp://www.sqlservercentral.com/Forums/Topic129731-32-1.aspxAlways good to review the basics. I noticed that the .\ usage in figure 7 was no different than if I click the ... button without it. Am I missing something?I learned something about security recently that surprised me. The situation is like this. I have a member who is part of a server group. That group has permissions to a database. The specified user cannot connect directly to the database using Query Analyzer. I was a bit surprised, shows an advantage to SQL logins as opposed to Windows login. It's also possible that I didn't do a valid attempt and my result is meaningless.Also recently I found a use for Deny. I have a reporting database where we want to strictly limit user's access to data. All of these users are in a server group. The ERP system has a set of views provided by the vendor. So we created a second database, created a 'select * from livedb..' set of queries by the same name as the vendor queries and gave the group select permissions to said views.In the production DB, we denied them select on sysobjects and no select permissions on the vendor views. Apparently by denying the select on sysobjects, you also keep them from running sp_helptext on the views, so they can't see what the code is behind the vendor views.Fri, 03 Aug 2007 11:18:00 GMTWayne Westhttp://www.sqlservercentral.com/Forums/Topic129731-32-1.aspx<P>Helow! The article is very good and clear, but i need... how i can to do this with commands T-SQL...?? Help me!! thank you!!</P><P> </P>Thu, 13 Jan 2005 09:36:00 GMTBurela Miguel Angelhttp://www.sqlservercentral.com/Forums/Topic129731-32-1.aspxComments posted to this topic are about the content posted at <A HREF=http://www.sqlservercentral.com/columnists/sjones/beginningsqlserverloginsandusers.asp>http://www.sqlservercentral.com/columnists/Mon, 02 Aug 2004 14:59:00 GMTSteve Jones - SSC Editor