data access

Question

I do not know much about sql.

I am a network enginer and mostly deal with hardware and software programs.

I have a client that has wants to give someone permissin to access the database files. He writes his own software but what he is asking me is if he can have access to the files but only wants read only privages so if anything happens he can not be at fault. I was thinking about changing folder permissions to give him read only but not sure if he will still be able to do what he needs to. This is within a 2008 domain. I will create him his own name but what do you think is the best way for me to go about giving him read only so that he can access the data to pull information but not be able to change anything.

The program they use to input the information is called IBS. This is for a golf course. I am not sure if what I said makes any sense but if it does and anyone can help let me know. 

Thanks

Answer 1

he is asking me is if he can have access to the files but only wants read only privages

Hello,

It's unclear why your customer requires "read only" access for the database files, because it makes no sense: You can't do anything with the database files, you can't read any information from the database files directly, there is no "reader/editor" tool available for it and so on.

SQL Server is a server system, the database must be attached to it, then you can connect to SQL Server using data access tools to query informations from the database.

---

Olaf Helper

Blog Xing

Answer 2

And when SQL Server starts, it takes an exclusive lock on the files.

But you can consider creating a login for this user and grant limited permissions to that login.

---

Rick Byham, Microsoft, SQL Server Books Online, Implies no warranty

Answer 3

It appears he is scared to work with live data. Give him a copy (which he can rename) so that he can work on it to gain confidence. Read-Only permission is perhaps not useful.

---

mysorian