oracle等保中有条要求:应重命名或删除默认账户,修改默认账户的默认口令。给的建议是修改sys,system默认账户名称,避免使用常见用户名称;以下记录了两种方法来实现上面的要求:Oracle重命名sys操作记录 方法一:通过用户的信息是
select username,user_id from dba_users where username=‘SYS‘;
USERNAME USER_ID
------------------------------ ----------
SYS 0
或者:
select user#,name from user$ where name=‘SYS‘;
USER# NAME
---------- ------------------------------
0 SYS
SQL> update user$ set name=‘SYSA‘ where user#=0;
1 row updated.
SQL> commit;
Commit complete.
SQL> alter system checkpoint;
System altered.
SQL> alter system flush shared_pool;
System altered.
SQL> conn sysa/sys as sysdba
Connected.
SQL> select t1.ksppinm,t2.ksppstvl,t1.ksppdesc from x$ksppi t1,x$ksppcv t2 where t1.indx=t2.indx and t1.ksppinm like ‘_enable_rename_use
r‘;
KSPPINM
--------------------------------------------------------------------------------
KSPPSTVL
--------------------------------------------------------------------------------
KSPPDESC
--------------------------------------------------------------------------------
_enable_rename_user
FALSE
enable RENAME-clause using ALTER USER statement
SQL> alter system set "_enable_rename_user"=true scope=spfile;
System altered.
SQL> startup restrict force
ORACLE instance started.
Total System Global Area 3290345472 bytes
Fixed Size 2232840 bytes
Variable Size 1795165688 bytes
Database Buffers 1476395008 bytes
Redo Buffers 16551936 bytes
Database mounted.
Database opened.
SQL> alter user sysa rename to sys identified by syspwd;
User altered.
第二种方法需要重启数据库,没有方法一快捷
Oracle重命名sys或system操作记录
原文:https://blog.51cto.com/8355320/2529771
--结束END--
本文标题: Oracle重命名sys或system操作记录
本文链接: https://www.lsjlt.com/news/7892.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
下载Word文档到电脑,方便收藏和打印~
2024-05-14
2024-05-14
2024-05-14
2024-05-14
2024-05-14
2024-05-13
2024-05-13
2024-05-13
2024-05-13
2024-05-12
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
0