Readonly commandReadonly commandSyntaxREADONLY { ON | OFF }Description
Sets the current connection to a "read-only" connection, as if
the current user were defined as a readOnlyAccess user.
(For more information about database authorization, see the .)
Exampleij> connect 'jdbc:derby:menuDB';
ij> readonly on;
ij> SELECT * FROM menu;
COURSE |ITEM |PRICE
-----------------------------------------------
entree |lamb chop |14
dessert |creme brulee |6
appetizer |baby greens |7
entree |lamb chop |14
entree |lamb chop |14
dessert |creme brulee |6
6 rows selected
ij> UPDATE menu set price = 3;
ERROR 25502: An SQL data change is not permitted for a read-only
connection, user or database.