在ILMA中建立一個新的系統管理使用者！

前提條件是：

1.  Oracle Database 11g R2 database 已經安裝。

2. Oracle Application Express 已經安裝。

我們可以使用下面兩個步驟建立ILM_ADMIN使用者。
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

--- 注意這個地方。使用者名稱要大寫。
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.

測試：使用ilm_admin使用者登入系統。

在瀏覽器中輸入下列地址：

http://localhost:8081/apex/f?p=737677

輸入ilm_admin和密碼：

正確的話應該返回如下介面：