ODBiC Discussion Board

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?


Post Your Reply:

E-mail  optional

HTTP Link: 
Link text: 


Copyright ©1997-2003, Roger Harris. All rights reserved.