Re: Make a table read only

From: baldo <dana.stockler_at_twobits.no>
Date: 25 Jun 2001 00:44:59 -0700
Message-ID: <a47be8fc.0106242344.e187bfa@posting.google.com>

What about two roles XXX_READONLY and XXX_READWRITE. The XXX_READONLY has only read access to the table, the XXX_READWRITE role has read and write. Make both roles non-default. Define a password if you like. Let your application activate the desired role.

Just a thought. I do something similar now.

Regards,
Baldo

> How can I make a table read only? We are using a POS system that uses
> one login for all users. I need to be able to toggle the table from
> read only to write and back. I am using 7.3.4 on AIX 4.3.1.
Received on Mon Jun 25 2001 - 02:44:59 CDT