Change the informix database to read only

Posted in 2008

GULSHAN KUMAR — Mon, 01 Dec 2008 11:42:10 — source: IIUG Forums & Mailing Lists

Dear All, I want to put one of my informix database to read only mode. Can anybody provide the solution to change the database to read only mode. Thanks, Gulshan

↪ replying to GULSHAN KUMAR

R Fo — Mon, 01 Dec 2008 14:16:18 — source: IIUG Forums & Mailing Lists

Hi Gulshan Informix have no "read only mode". No databases have it... IDS has "on-line" mode that means all data inside the instance is available to access and modify if the user have permissions to do updates/deletes/inserts. If you want to protect your data, removing the permissions to users/applications do not modify the data in the database, run the statements to revoke insert/update/delete permissions from users in tables. I mean: If you have a table usertable and you want to protect the data , get the list of users in database who have permission to insert/delete/update this table. Run the statement: revoke insert,update,delete on usertable from user1, user2, user3...;If you want , give 'select' permission to users access the data only to 'read' Best regards R Ferronato > To: ids@iiug.org> From: gulshank@infotechsw.com> Subject: Change the informix database to read only [14167]> Date: Mon, 1 Dec 2008 06:42:10 -0500> > Dear All, > > I want to put one of my informix database to read only mode. > Can anybody provide the solution to change the database to read only mode. > > Thanks, > Gulshan _________________________________________________________________ Explore the seven wonders of the world http://search.msn.com/results.aspx?q=7+wonders+world&mkt=en-US&form=QBRE

↪ replying to R Fo

Knox, Ernest — Mon, 01 Dec 2008 17:09:11 — source: IIUG Forums & Mailing Lists

You have read-only mode during HDR replication as the secondary from the primary, which is On-line mode . *************************************** Ernie Knox Sears Holding Co. IT Database Administrator Specialist 3333 Beverly Rd., B4-266A Hoffman Estates, IL. 60179 Office: (847) 286-5735 Email: eknox@searshc.com Blackberry: 2244650553@messaging.sprintpcs.com Page via Skytel: 2244650553@sprint.skytel.com " Yes we can make a Change! " " It's always a great day to watch Football - GO LIONS, TIGERS and BEARS! " *************************************** -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of R Fo Sent: Monday, December 01, 2008 8:16 AM To: ids@iiug.org Subject: RE: Change the informix database to read only [14171] Hi Gulshan Informix have no "read only mode". No databases have it... IDS has "on-line" mode that means all data inside the instance is available to access and modify if the user have permissions to do updates/deletes/inserts. If you want to protect your data, removing the permissions to users/applications do not modify the data in the database, run the statements to revoke insert/update/delete permissions from users in tables. I mean: If you have a table usertable and you want to protect the data , get the list of users in database who have permission to insert/delete/update this table. Run the statement: revoke insert,update,delete on usertable from user1, user2, user3...;If you want , give 'select' permission to users access the data only to 'read' Best regards R Ferronato > To: ids@iiug.org> From: gulshank@infotechsw.com> Subject: Change the informix database to read only [14167]> Date: Mon, 1 Dec 2008 06:42:10 -0500> > Dear All, > > I want to put one of my informix database to read only mode. > Can anybody provide the solution to change the database to read only mode. > > Thanks, > Gulshan _________________________________________________________________ Explore the seven wonders of the world http://search.msn.com/results.aspx?q=7+wonders+world&mkt=en-US&form=QBRE ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to R Fo

jak aka — Tue, 02 Dec 2008 06:50:52 — source: IIUG Forums & Mailing Lists

Normally , I use "dbschema -d DATABASE -p all " and use "sed" chang grant->revoke , to->from. Then I will have script to revoke all user permission. (Don't forget to keep the original file). You can use "oninit -j" to turn IDS into Single-user mode which only informix user can use the instance. In 11.50, You can allow some user to access the database in administration mode, not only informix user. ________________________________ From: R Fo <roeferr@hotmail.com> To: ids@iiug.org Sent: Monday, December 1, 2008 9:16:18 PM Subject: RE: Change the informix database to read only [14171] Hi Gulshan Informix have no "read only mode". No databases have it... IDS has "on-line" mode that means all data inside the instance is available to access and modify if the user have permissions to do updates/deletes/inserts. If you want to protect your data, removing the permissions to users/applications do not modify the data in the database, run the statements to revoke insert/update/delete permissions from users in tables. I mean: If you have a table usertable and you want to protect the data , get the list of users in database who have permission to insert/delete/update this table. Run the statement: revoke insert,update,delete on usertable from user1, user2, user3...;If you want , give 'select' permission to users access the data only to 'read' Best regards R Ferronato > To: ids@iiug.org> From: gulshank@infotechsw.com> Subject: Change the informix database to read only [14167]> Date: Mon, 1 Dec 2008 06:42:10 -0500> > Dear All, > > I want to put one of my informix database to read only mode. > Can anybody provide the solution to change the database to read only mode. > > Thanks, > Gulshan _________________________________________________________________ Explore the seven wonders of the world http://search.msn.com/results.aspx?q=7+wonders+world&mkt=en-US&form=QBRE ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.