It is a common practice in Teradata to have some databases with PERM space that contain only tables.
Then, other databases contain only views. These view databases require no PERM space and are the only databases that users have privileges to access.
The views in these databases control all access to the real tables in other databases. They insulate the actual tables from user access
No comments:
Post a Comment