Appendix B Creating a DBEnvironment

ODBCLink/SE Reference Manual

Plan the security structure of the DBEnvironment. Decide which users will be granted access to the DBEnvironment, databases within the DBEnvironment, and tables within the databases.

Create the account where the DBEnvironment is to reside.

Grant authorizations to users who will be using the test DBEnvironment.

Create the DBEnvironment, including databases and tables.

After you setup the DBEnvironment, ensure that you can connect to it. For example,

: isql

isql=> CONNECT TO 'PartsDBE.SomeGrp.SomeAcct'; isql=> SELECT * FROM SYSTEM.TABLE;

:

At this point you should see the system table information.

:

U[p],d[own],l[eft],r[ight],t[op],b[ottom],pr[int]<n>,or e[nd]

>e;

isql=> exit;

 

ODBCLink/SE

72

©M.B. Foster Associates Limited 1995-2000

Page 82
Image 82
HP MPE/iX 6.x Operating System manual Up,down,left,right,top,bottom,printn,or end Isql= exit