USER Restrictions with SETOPTION
by Louis, April 12, 2005 05:27
I'm trying block certain user to use a update or insert query.
Because most of the scripts are ready and a user restriction was neven neccesary I can't change all of the scripts' structure.
So using SETOPTION SQL_ACCESS_MODE='read_only' I could disallow certain users to update the database.
But it seems that you only can use this command once, before any SQL query. I don't know if ODB or Access is handling this command.
Does anyone have ideas on this problem? Should I use a simple textfile to read out the user options?
Name E-mail optional TopicMessage:
HTTP Link: Link text: