|
|
Archives of the TeradataForum
Message Posted: Wed, 20 Jun 2007 @ 18:00:58 GMT
Subj: | | Re: Locking a Database for READ only |
|
From: | | Rob Paller |
Have you considered creating a role or set of roles that embody the necessary access rights you maintain for your users (including batch) to
maintain this data (Insert, Update, Delete). When you need to run this batch simply revoke the role(s) from the various users at the beginning of
the batch job and then grant the role(s) back at the successful completion of the batch.
| |