• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 370
  • Last Modified:

SQL Permissions

We are using a ODBC connection to allow users to update and change some tables in our SQL Server 2008.  However, it seems as though our permissions has changed on the server as they are not able to do this any more.  Even with a simple select statement.  We are using windows authentication and when I check with the ODBC  connection it test out fine.  

What permissions on the database should I be changing so that they can read, write, update, insert, alter sort of stuff.  I've taken over this SQL server from someone else.  We have a group with all of the users listed in it so I just need to change permissions for that group.  

Also do you need to restart a service or something when you change permissions on the database for it to take affect?

This is the most difficult thing they would do:
INSERT INTO AR.GIS.DEMO (ID, GEOID, GEOTYPE, TITLE, UserName)
SELECT ID, GEOID, GEOTYPE, TITLE, UserName
FROM OPENROWSET('MICROSOFT.JET.OLEDB.4.0', 'dBase IV;HDR=NO;IMEX=2; DATABASE=\\MA000XVSQL07\GIS\', 'select * from [DEMO.dbf]') AS DEMO
0
flfmmqp
Asked:
flfmmqp
  • 3
  • 2
  • 2
  • +1
2 Solutions
 
derekkrommCommented:
No restart necessary

Here's a list of SQL Server permissions/roles/etc

0
 
derekkrommCommented:
0
 
flfmmqpAuthor Commented:
After further review I think it is the ODBC connection but I don't understand.  The old one AR_SQLDB is the exact same as the new one that I just created with a different name AR.  I don't want to have to go change a bunch of code and redistribute it just to rename the ODBC connection.  I even deleted the old ODBC connection and recreated it and it still does not work.  It used to work.  
0
Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

 
lcohanDatabase AnalystCommented:
How is the database accessed by users via ODBC?
Each NT user has it's own ODBC and they are using their own NT credentials to access it via ODBC?
0
 
derekkrommCommented:
About ODBC: http://msdn.microsoft.com/en-us/library/ms714591(v=vs.85).aspx

If you're having permissions issues, its likely not ODBC that is causing them, but rather the underlying permissions on the database server itself.
0
 
lcohanDatabase AnalystCommented:
In my opinion the old one you deleted was configured with a (different) speciffic login/password that had sufficient rights in your server.database and it is obvoiously that's why it worked.
0
 
flfmmqpAuthor Commented:
I tried to accept a solution and was blocked.  Please feel free to do whatever you want but do not block me from asking a question.  I understand I left it open but I never felt I got a real answer.  That is the point right?

I have one freaking open question and I am paying for this service to be able to ask questions when I need answers quickly.  Not to have to go in and object to a question just to ask my question.  Horrible customer service and you are wasting my time.  Otherwise if you want to do this then making it a non-paying service and then I can live with these rules.  

0
 
mlmccCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 3
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now