Implementing Srvrinit on the Regional Node

To successfully implement srvrinit on an Oracle Database regional node, the table owner must possess the required privileges. You can grant these privileges without granting database administrator privileges to the table owner. This topic describes how to enable srvrinit to work in Oracle Database without granting database administrator privileges to the table owner.

To implement srvrinit on the regional node

1. Start SQL*Plus.

2. Log in as the system user, sys, or a database administrator user.

3. Run the following command:

   grant sse_role, connect, alter user, create user, create table, create session to table owner with admin option
   

   If you only grant sse_role, then SQL*Plus displays an error message.