The following example grants administrator privileges to CALVIN, who now has all privileges to all tables:
GRANT SYS_ADMIN_ROLE TO CALVIN;
You may also want to grant a user the right to perform data synchronization operations. To do this, execute the command:
GRANT SYS_SYNC_ADMIN_ROLE TO HOBBES
Note If the autocommit mode is set OFF, you need to commit your work. To commit your work use the following SQL statement: COMMIT WORK; If the autocommit mode is set ON, the transactions are committed automatically.