Oninit cdi / Archive
Talk to an expert →

Make Primary in an HDR pair READ ONLY

Posted in 2017

Topics: High Availability & Replication, Platform-Specific Issues

LARRY SORENSEN — — source: IIUG Forums & Mailing Lists

Solaris 10 IDS 11.50.FC5 ________________________________ I read on the IIUG site that there is no way to make a database READ ONLY (exception being the Secondary in an HDR pair). Is this still true? I want to still be able to read the data from the Primary database, but I do not want to allow updates for a period of time. Other than performing a Schema on the database and changing all the Grants to Revoke, is there an easier way to not allow Updates, Deletes and Inserts? Thank you. Larry

↪ replying to LARRY SORENSEN
Andreas Legner1 — — source: IIUG Forums & Mailing Lists

sysdbopen() setting a to-be-defined 'read_only' ROLE might be what you're looking for. From: "LARRY SORENSEN" <LSORENSEN25@msn.com> To: ids@iiug.org Date: 11/28/2017 11:46 PM Subject: Make Primary in an HDR pair READ ONLY [40290] Sent by: ids-bounces@iiug.org Solaris 10 IDS 11.50.FC5 ________________________________ I read on the IIUG site that there is no way to make a database READ ONLY (exception being the Secondary in an HDR pair). Is this still true? I want to still be able to read the data from the Primary database, but I do not want to allow updates for a period of time. Other than performing a Schema on the database and changing all the Grants to Revoke, is there an easier way to not allow Updates, Deletes and Inserts? Thank you. Larry ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

Glossary