HP 3000 Manuals HP 3000 Manuals
Granting Privileges to Access ORACLE Tables
For an Information Access user to access any tables in a specific ORACLE
database, you must grant the user CONNECT privilege to that database and
SELECT privilege to the tables. All ORACLE tables to which the PC user
has SELECT privilege will be listed in the Tables box in Information
Access.
All ORACLE users have access by default to the system views
ACCESSIBLE_TABLES and ACCESSIBLE_COLUMNS that are used by Access SQL/iX,
so it is usually not necessary to grant SELECT privilege to any system
tables. However, it is possible that these views do not exist or that
the user does not have SELECT privilege to them. In these cases, the DBA
must establish the view and/or grant SELECT privilege.
System tables are listed in the Tables box in Information Access. Users
can have read-only access to them if:
* they are the ORACLE user SYS or SYSTEM
* the environment variable ORACLE_TABLES is given the value of 1.
(SETVAR ORACLE_TABLES 1).
You can place the command SETVAR ORACLE_TABLES 1 in an IASQL file in the
user's logon group and account.
See Chapters 17 and 18 of the ORACLE RDBMS Database Administrator's Guide
Version 6.0, for information on granting privileges to ORACLE users.