oracle添加用户并给予管理员身份登陆
时间:2021-07-01 10:21:17
帮助过:63人阅读
![技术分享图片](https://img.gxlcms.com//Uploads-s/new/2020-10-11-qlqqti/20181127234153991442.png)
show user;--显示当前用户
![技术分享图片](https://img.gxlcms.com//Uploads-s/new/2020-10-11-qlqqti/20181127234154391848.png)
conn system/admin;--切换用户
![技术分享图片](https://img.gxlcms.com//Uploads-s/new/2020-10-11-qlqqti/20181127234154864523.png)
![技术分享图片](https://img.gxlcms.com//Uploads-s/new/2020-10-11-qlqqti/20181127234155194614.png)
CREATE user admin identified by admin;--创建用户admin,密码admin
![技术分享图片](https://img.gxlcms.com//Uploads-s/new/2020-10-11-qlqqti/20181127234155670218.png)
alter user admin account unlock;--解锁
![技术分享图片](https://img.gxlcms.com//Uploads-s/new/2020-10-11-qlqqti/20181127234156032536.png)
grant create session to admin; --给予管理员权限
![技术分享图片](https://img.gxlcms.com//Uploads-s/new/2020-10-11-qlqqti/20181127234156358721.png)
切换用户
![技术分享图片](https://img.gxlcms.com//Uploads-s/new/2020-10-11-qlqqti/20181127234156628262.png)
oracle添加用户并给予管理员身份登陆
标签:alt inf 添加 grant unlock show count session 创建用户