On 12/9/15 5:16 PM, Anjana Prakash wrote:
Hi,
How to enable database locks during db export and import using system
procedure.
SYSCS_UTIL.SYSCS_EXPORT_TABLE and SYSCS_UTIL.SYSCS_IMPORT_TABLE
Thanks,
Anjana
Hi Anjana,
I don't know of an easy way to lock the database for user by only one
person. The following might work (I haven't tried this). For this to
work, your database must be protected by authentication and SQL
authorization. Please consult the Derby Security Guide sections on these
topics:
http://db.apache.org/derby/docs/10.12/security/cseccsecure42374.html and
http://db.apache.org/derby/docs/10.12/security/csecauthorization.html
1) Using the coarse-grained authorization properties, set the database
so that only the database owner can connect to it.
2) Bring down the database.
3) Have the database owner boot the database and perform the sequence of
exports or imports.
4) Unset the coarse-grained authorization properties so that any valid
user can connect.
5) Bring down the database.
6) Reboot the database.
Hope this helps,
-Rick
