RE: read-only access

grant connect to db_inq; grant select on <table_name> to db_inq;.... Have the users connect as db_inq Would give you a user who could do inquiries. Do note, ad hoc user inquiry can cripple your database too. Will >===== Original Message From "Graeme Muirhead" <csi@muirhead.freeuk.com> ===== >Is there an easy way of restricting users to have read only (ie select) >access to all tables ie so that users using ODBC for querying the database >do not accidentally delete rows. We are using INFORMIX-SE 7.24 with Informix >ODBC Driver, version 3.3/Client SDK 2.30. > >Thanks > >Graeme Muirhead >g_muirhead@csisystems.co.uk ------------------------------------------------------------ This e-mail has been sent to you courtesy of OperaMail, as a free service from Opera Software, makers of the award-winning Web Browser, Opera. Visit us at http://www.opera.com/ or our portal at: http://www.myopera.com/ Your free e-mail account is waiting at: http://www.operamail.com/ ------------------------------------------------------------