Group Accounts
As an alternative to allowing each user private authorization to each remote node, the Net system administrator may define a login to serve as a group account for each local node and define global access to this account through netutil or ingnet. Ingres Star will connect to Ingres on the local node using the group account name and not the Ingres Star user’s name.
For example, consider the following configuration:
• User dave and the Star Server reside on the london node. On node london, user dave has made no private authorization entries in netutil or ingnet other than to authorize his access to the london node.
• netutil or ingnet has a global authorization on london authorizing francis to access the paris node.
Dave uses Ingres Star on node london to access data from the paris node. Ingres Star’s session with the database on paris will be in the name of francis; Dave is able to access only those tables with permissions granted to the francis login.