Oracle
在 Oracle 數據庫中更改 sys 的密碼需要什麼權限?
我們的身份管理工具希望定期更改 sys 密碼。它因 ORA-01031 而失敗。我需要授予身份管理工具使用者哪些權限或角色才能更改 sys 密碼?
您需要以具有 SYSDBA 權限的使用者身份進行連接。即使“更改任何使用者”也不夠。
SQL> select * 2 from session_privs 3 where privilege like 'ALTER ANY%'; PRIVILEGE ---------------------------------------- ALTER ANY TABLE ALTER ANY CLUSTER ALTER ANY INDEX ALTER ANY SEQUENCE ALTER ANY ROLE ALTER ANY PROCEDURE ALTER ANY TRIGGER ALTER ANY MATERIALIZED VIEW ALTER ANY TYPE ALTER ANY LIBRARY ALTER ANY OPERATOR ALTER ANY INDEXTYPE ALTER ANY DIMENSION ALTER ANY OUTLINE ALTER ANY EVALUATION CONTEXT ALTER ANY RULE SET ALTER ANY RULE ALTER ANY SQL PROFILE ALTER ANY EDITION ALTER ANY ASSEMBLY ALTER ANY MINING MODEL ALTER ANY CUBE DIMENSION ALTER ANY CUBE ALTER ANY SQL TRANSLATION PROFILE ALTER ANY MEASURE FOLDER ALTER ANY CUBE BUILD PROCESS ALTER ANY ATTRIBUTE DIMENSION ALTER ANY HIERARCHY ALTER ANY ANALYTIC VIEW 29 rows selected. SQL> alter user sys identified by newpass; alter user sys identified by newpass * ERROR at line 1: ORA-01031: insufficient privileges