Archives of the TeradataForum
Message Posted: Thu, 01 Apr 2004 @ 11:26:06 GMT
| Subj: | | User groups & methods of access |
| |
| From: | | Anomy Anom |
<-- Anonymously Posted: Thursday, April 01, 2004 06:23 -->
Currently we have a number of usergroups and have a database containing views for each usergroup. The usergroup has select access on their
complete views database. Initially we had a requirement to provide different views of the same table to these usergroups. This means that if a
usergroup requires access to data we create a view for them in their own views database.
However as we implement more tables we are finding that most usergroups require the same view to the data. Therefore we are considering
changing to only one views database and granting usergroups access to a set of views within this database. If usergroups require different access
to the same table, different views are created.
Are there any thoughts on this approach or what other sites do to control user access ?
( We are at V2 R4.1 )
| 
