 |
 |
Archives of the TeradataForum
Message Posted: Thu, 11 Oct 2007 @ 17:28:45 GMT
| Subj: | | Re: Separate database for Views and Locking |
| |
| From: | | Guilbeau, Colby B |
The database with views referencing a database of tables allows for a simple permission scheme. You can grant permission at the database level
for the views. The view database has to have select with grant on the database containing the tables. Views provide for a level of abstraction
from the base tables. You can build semantic levels in sets of views to meet security permission levels, reporting requirements, etc.
If you prepare your views with locking row for access it may be used for read or write. When you use it for an update the lock will escalate
automatically. Locking row for access is less typing than having to explicitly name access locks.
| |
