Purpose: Occasionally you may find it convenient to access Oracle’s SQL*Plus from inside the ACCENT R environment. You may use this to grant and revoke privileges, or test your queries interactively. You may also test your queries through the windowed SQL interface of OSQL. Consult the Oracle SQL Language Reference Manual for more information. You must be licensed for SQL*Plus in order to use the command.
ORACLE
*ORACLE
Enter user-name:
Enter password:
Connected to: ORACLE RDBMS V6.0.26.7.0, transaction processing
option - ProductionSQL> HELP GRANT
SQL> GRANT ALL PRIVILEGES ON BOOKS_ORA TO PUBLIC Grant succeeded.
SQL> EXIT
Disconnected from ORACLE RDBMS V6.0.26.7.0 transaction processing
option - Production*