Authorization Examples
This section gives examples of using installation passwords or netutil or ingnet to define the network configuration of a Ingres Star database.
Example 1
In the following diagram, client and Ingres Star installation reside on node_A. Tables in the distributed database, node_A::sales/star, are registered from databases node_B::b_sales/ingres and Node_C::c_sales/ingres.
• To set installation passwords for node_B and node_C:
– On node_B, set installation password to <b_password>.
– On node_C, set installation password to <c_password>.
• To set installation passwords for node_B and node_C on node_A:
– On node_A, enter <b_password> as installation password for node_B.
– On node_A, enter <c_password> as installation password for node_C.
Users of node_A::sales/star can now access registered tables from node_B::b_sales/ingres and node_C::c_sales/ingres without each having to provide private remote authorization from node_A to both node_B and node_C.
Example 2
In the following diagram, the Ingres Star application and the Star Server both run on Node A. The Ingres Star distributed database consists of an SQL Enterprise Access on Node B and an Ingres local DBMS on Node C.
The netutil or ingnet requirements for running the application on Node A are as follows:
• On Node A:
– There must be an authorization entry for a user on Node A. (Be sure that you do not overlook this authorization step.) The node name supplied to netutil or ingnet should be the same as the value of local_vnode, as described in Defining User Authorization to the Local Node.
– There must be private or global entries for node definition and user authorization for Node B and Node C.
• On Node B and Node C:
No netutil or ingnet definitions are required.
Example 3
In this example, the Ingres Star application runs on Node A and connects to a Star Server on the remote node, Node B. There is an Ingres local DBMS on Node C.
The netutil or ingnet requirements for running the application on Node A are as follows:
• On Node A:
– There must be a node entry for Node B.
– There must be an authorization entry for a user on Node B.
• On Node B:
– There must be a node entry for Node C.
– There must be an authorization entry for a user on Node C.
Note that netutil or ingnet must be used on both Node A and Node B.
Example 4
In this example, the Ingres Star application, the Star Server, and the local databases are all on the same installation on one node.
Last modified date: 04/03/2024