Beginning SQL Server - Logins and Users

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Steve Jones » Beginning SQL Server - Logins and Users

Beginning SQL Server - Logins and Users

Rate Topic

Display Mode

Topic Options

Author

Message

Steve Jones - SSC Editor

Posted Monday, August 02, 2004 2:59 PM

SSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 5:09 AM
Points: 31,526, Visits: 13,864

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #129731

Burela Miguel Angel

Posted Thursday, January 13, 2005 9:36 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, January 13, 2005 9:45 AM
Points: 1, Visits: 1

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!!

Post #155411

Wayne West

Posted Friday, August 03, 2007 11:18 AM

SSC Eights!

Group: General Forum Members
Last Login: Wednesday, May 09, 2012 10:26 AM
Points: 891, Visits: 1,958

Always 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.

Post #387874

SQLSharma

Posted Thursday, February 04, 2010 7:44 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, March 13, 2013 4:55 PM
Points: 162, Visits: 96

Steve, excellent post on logins/users! Do you have an updated 2005/2008 version of this? Any help would be greatly appreciated. Thanks!

Sharma

Post #860116

« Prev Topic | Next Topic »

Permissions