Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Either the user should be an Oracle sysdba user or have the following privileges
  2. CONNECT
  3. RESOURCE
  4. CREATE ANY TABLE
  5. DROP ANY TABLE
  6. CREATE ANY TRIGGER
  7. DROP ANY TRIGGER
  8. CREATE ANY VIEW
  9. DROP ANY VIEW
  10. CREATE ANY PROCEDURE
  11. DROP ANY PROCEDURE
  12. CREATE ANY SEQUENCE
  13. DROP ANY SEQUENCE

SQL:

GRANT CONNECT, RESOURCE, CREATE ANY TABLE, DROP ANY TABLE, CREATE ANY TRIGGER, DROP ANY TRIGGER, CREATE ANY VIEW, DROP ANY VIEW, CREATE ANY PROCEDURE, DROP ANY PROCEDURE, CREATE ANY SEQUENCE, DROP ANY SEQUENCE TO <USERNAME>

Note: If you are using the ORACLE database, it is mandatory to install the Oracle client on the machine that is hosting the Tomcat/JBoss server. Ensure that the system variable ORACLE_HOME is set properly and the system variable PATH contains ORACLE_HOME/bin.

...