Solved

SQL server permissions ?

Posted on 2008-10-27
2
196 Views
Last Modified: 2012-05-05
I found a script that let me look at permissons on the server. There are two sets of permissions on the database for the user account.  One set gives all the object_or_coumn and the other set for the same User ID give a NULL in that column.  Could this be causing a conflict as to permissons for this user ID or is the Null Value suppose to be here.  This ID cannot logon to the database.  Get error.

xxx\IUSR_xx      WINDOWS_USER  OBJECT_OR_COLUMN  QSASafetyInfo              ALTER      GRANT
xxx\IUSR_xx      WINDOWS_USER OBJECT_OR_COLUMN   QSASafetyInfo      CONTROL      GRANT
xxx\IUSR_xxxWINDOWS_USER OBJECT_OR_COLUMN QSASafetyInfo      DELETE      GRANT
xxx\IUSR_xxxWINDOWS_USER OBJECT_OR_COLUMN QSASafetyInfo      INSERT      GRANT
xxx\IUSR_xxx WINDOWS_USER OBJECT_OR_COLUMN QSASafetyInfo      SELECT      GRANT
Here is the second set that shows up.

xxx\IUSR_xxxWINDOWS_USER      DATABASE      NULL      AUTHENTICATE      GRANT
xxx\IUSR_xxxWINDOWS_USER      DATABASE      NULL      CONTROL      GRANT
xxx\IUSR_xxxWINDOWS_USER      DATABASE      NULL      CONNECT      GRANT
xxx\IUSR_xxxWINDOWS_USER      DATABASE      NULL      DELETE      GRANT
xxx\IUSR_xxxWINDOWS_USER      DATABASE      NULL      EXECUTE      GRANT
xxx\IUSR_xxxWINDOWS_USER      DATABASE      NULL      INSERT      GRANT
xxx\IUSR_xxxWINDOWS_USER      DATABASE      NULL      SELECT      GRANT
xxx\IUSR_xxxWINDOWS_USER      DATABASE      NULL      UPDATE      GRANT
xxx\IUSR_xxxWINDOWS_USER      OBJECT_OR_COLUMN      QSASafetyInfo UPDATE      GRANT
0
Comment
Question by:kdschool
2 Comments
 
LVL 13

Accepted Solution

by:
devsolns earned 500 total points
ID: 22814254
More than likely this issue is due to an orphaned user in SQL Server.  This can be caused by a restore of a database, etc.  Run this command and see if the login you speak of is orphaned:

sp_change_users_login 'report'


Read more about this from here:
http://support.microsoft.com/kb/274188
0
 

Author Comment

by:kdschool
ID: 22814506
I ran the command and the report window and it makes two columns. UserName and UserSID and  is blank but Messages says executed correctly.  
0

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Join & Write a Comment

This article will describe one method to parse a delimited string into a table of data.   Why would I do that you ask?  Let's say that you need to pass multiple parameters into a stored procedure to search for.  For our sake, we'll say that we wa…
Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

759 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now