Readonly commandThe Readonly command sets the current connection to
a "read-only" connection, as if the current user were defined as a
readOnlyAccess user.Readonly command
For more information about database authorization, see "Configuring user
authorization" in the .
SyntaxREADONLY { ON | OFF }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.