Hi all,
this is part one of a 2-part problem.
I have an MS SQL db with tables. I want everything secure, with data just written into the db (excluding my SA priveleges to query the db),
EXCEPT. I want to have a table that is open for to our users to extract data. (there is a generic search through the table to extract a string which is changed periodically)

How would I establish the security for my MS SQL db so that all the users are 'write' only. And can 'read' only that one table. (MyDSN: Mytable: column1 column2 column3 column4 column5)
Thanks in advance.