ODBC Access Requirements
Enterprise Access 11 ODBC Gateway provides generic access to ODBC hosts via host-specific ODBC drivers. To access an ODBC host using the Enterprise Access ODBC Gateway, the following conditions must be met:
• User logins must be defined to the ODBC host.
• Permission must be granted to access each ODBC host database.
• Each user ID (or the group that contains the user ID) in the database must be granted the following permissions:
– Create Table
– Create View
– Create Stored Procedure
• The Ingres user can optionally be made the DBA of the database.
• An ODBC SYSTEM Data Source Name (DSN) can be defined for the database. The gateway can use the ODBC System DSN to access the ODBC host database on the local or remote system. You should configure the DSN with an explicit database name rather than use the default.
Grant User Permissions (ODBC)
The following example grants permissions to a user 'INGRES' and a non-privileged user 'FRED'. The example grant statements need to be executed by the database administrator of the ODBC host database:
To grant permissions
1. Connect as a database administrator to the ODBC host instance.
2. Assign the permissions as follows:
GRANT DBADM, CREATETAB, CONNECT ON DATABASE TO USER INGRES;
GRANT CREATETAB, CONNECT ON DATABASE TO USER FRED;