Set database to read-only

jxh · #1 (**permalink**) 09-04-03, 11:56

Please can someone advise me how to set my Informix database to read only?

gurey · #2 (**permalink**) 09-04-03, 12:38

Quote:

Originally posted by jxh
Please can someone advise me how to set my Informix database to read only?

Hi,

Is not possible to setear it to read only you can execute "database xxxxx exclusive" or clear all the permissions of connect, resource, dba and rolles.

Gustavo.

tmullins · #3 (**permalink**) 09-10-03, 16:28

To set the database to "read only" you have to revoke all permissions on every table to all users. Then you have to grant select permissions on all tables to all users.

Internet Services

Web Development

Digital Marketing

Consumer Tech