Thursday, January 17, 2013 6:13 PM
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.
Thursday, January 17, 2013 6:40 PM
he is asking me is if he can have access to the files but only wants read only privages
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 HelperBlog Xing
Friday, January 18, 2013 5:04 PM
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
Saturday, January 19, 2013 8:37 PM
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.