oracle中数据库(user)重命名

1 重命名过程

--oracle连接conn / as sysdba--创建用户并授权create user user_name identified by pwd;grant connect,resource to user_name;--尝试修改user_name，报错：选项缺失或无效alter user old_user rename to new_user identified by new_pwd;--更改系统设置，scope=spfile还不知道什么意思alter system set "_enable_rename_user"=true scope=spfile;--以restrict mode重启oracle，可以看一下oracle的启动/关闭过程shutdown immediatestartup restrict--再次修改，提示：user is alterdalter user old_user rename to new_user identified by new_pwd;

2 oracle连接问题

conn / as sysdbashow user;  --user is "sys"/*  发现conn user/pwd as sysdba中的user/pwd写成任意string都能登陆执行show user;    结果都是"sys"原因是oracle执行的操作系统验证，查看ORA_DBA用户组，已包含当前登陆账号*/