To execute LOGGING ONLINE ARCHIVE ON, the user name specified in the logon statement must have one of these privileges:
- DUMP privilege on the database or table that being logged. The privilege is granted to a user or an active role for the user.
- Ownership of the database or table.