Re: Restricting ODBC access

Posted in 1998

Dave Otto — Wed, 11 Feb 1998 15:12:51 -0800 — source: Informix-list mailing list archive (1991-1998)

Easy if you are running 7.1+. Use ROLES. If there is no default role defined, then the first the application must do is execute the "set role..." statement. Unless the user has access to a SQL command AND knows the appropriate role to set, s/he will be locked out. Jacob Salomon wrote in message <34E224B1.33FF130C@garpac.com>... >Hi Family. > >I have a client with a serious concern. > .... >Can anyone come up with a way to prevent database access via ODBC? I >can't simply deny ODBC drivers to all PC users - there are other >databases to be accessed. The restriction I need should be settable on >a database by database basis. (Say that fast 10 times. ;-) Ideally, it >should be able to restrict data modifications via ODBC. >