GRANT is a native SQL command that authorizes users to access Oracle tables. As a run-time requirement, this command must be issued after the adapter is installed. It is also required for the AUTOORA facility in order to allow access to the Data Dictionary and Directory system tables.
You need to know the command syntax and have authorization for the tables or views and plans or modules in question. If you are unfamiliar with the GRANT command, contact your Oracle database administrator for assistance.
To distribute SELECT privileges, issue the following command.
GRANT SELECT ON object_name TO {ouserid|PUBLIC} ;
where:
Is the name of the Oracle table or view.
Is an authorized user ID for an individual user.
Allows all users to access the specified table or view.
Note: Additional privileges may be required to use two adapter features, FOCUS CREATE FILE and ON TABLE HOLD FORMAT SQLORA, which dynamically create Oracle tables with indices.
Information Builders |