Create a new management user in Ilma!

Prerequisites:

1. Oracle Database 11g R2 database has been installed.

2. Oracle Application Express has been installed.

We can use the following two steps to create an ilm_admin user.
Sqlplus/As sysdba
Create user ilm_admin identified by ilm_admin default tablespace ILM;

SQL> @ grant_privs ilm_admin

Session altered.

Session altered.

Old 1: grant manage tablespace to & ilm_user
New 1: grant manage tablespace to ilm_admin

Grant succeeded.

Old 1: grant alter tablespace to & ilm_user
New 1: grant alter tablespace to ilm_admin

Grant succeeded.

Old 1: grant alter any table to & ilm_user
New 1: grant alter any table to ilm_admin

Grant succeeded.

Old 1: grant drop any table to & ilm_user
New 1: grant drop any table to ilm_admin

Grant succeeded.

PL/SQL procedure successfully completed.

 

 

Old 1: grant advisor to & ilm_user
New 1: grant advisor to ilm_admin

Grant succeeded.

Old 1: grant alter any table to & ilm_user
New 1: grant alter any table to ilm_admin

Grant succeeded.

Old 1: grant drop any table to & ilm_user
New 1: grant drop any table to ilm_admin

Grant succeeded.

Old 1: grant manage tablespace to & ilm_user
New 1: grant manage tablespace to ilm_admin

Grant succeeded.

Old 1: grant alter tablespace to & ilm_user
New 1: grant alter tablespace to ilm_admin

Grant succeeded.

Old 1: grant execute on ilm_toolkit.ilm_toolkit to & ilm_user
New 1: grant execute on ilm_toolkit.ilm_toolkit to ilm_admin

Grant succeeded.

Creating the ILM $ user package for immutability features...

Old 2: l_username varchar2 (30): = '& ilm_user ';
New 2: l_username varchar2 (30): = 'ilm _ admin ';
Declare
*
Error at line 1:
ORA-01435: user does not exist
ORA-06512: At line 51

--- Pay attention to this place. The username must be capitalized.
SQL> @ grant_privs ilm_admin

Session altered.

Session altered.

Old 1: grant manage tablespace to & ilm_user
New 1: grant manage tablespace to ilm_admin

Grant succeeded.

Old 1: grant alter tablespace to & ilm_user
New 1: grant alter tablespace to ilm_admin

Grant succeeded.

Old 1: grant alter any table to & ilm_user
New 1: grant alter any table to ilm_admin

Grant succeeded.

Old 1: grant drop any table to & ilm_user
New 1: grant drop any table to ilm_admin

Grant succeeded.

PL/SQL procedure successfully completed.

 

 

Old 1: grant advisor to & ilm_user
New 1: grant advisor to ilm_admin

Grant succeeded.

Old 1: grant alter any table to & ilm_user
New 1: grant alter any table to ilm_admin

Grant succeeded.

Old 1: grant drop any table to & ilm_user
New 1: grant drop any table to ilm_admin

Grant succeeded.

Old 1: grant manage tablespace to & ilm_user
New 1: grant manage tablespace to ilm_admin

Grant succeeded.

Old 1: grant alter tablespace to & ilm_user
New 1: grant alter tablespace to ilm_admin

Grant succeeded.

Old 1: grant execute on ilm_toolkit.ilm_toolkit to & ilm_user
New 1: grant execute on ilm_toolkit.ilm_toolkit to ilm_admin

Grant succeeded.

Creating the ILM $ user package for immutability features...

Old 2: l_username varchar2 (30): = '& ilm_user ';
New 2: l_username varchar2 (30): = 'ilm _ admin ';

PL/SQL procedure successfully completed.

Test: Use the ilm_admin user to log on to the system.

Enter the following address in the browser:

Http: // localhost: 8081/apex/F? P = 737677

Enter ilm_admin and password:

If it is correct, the following interface should be returned: