计算
安全
数据库
网络和加速
企业服务
创建用户
SQL> create user soe identified by soe default tablespace soe temporary tablespace temp;
User created.
查询用户的默认表空间
SQL> set line 200
SQL> col username for a30
SQL> col account_status for a20
SQL> select username,account_status,created from dba_users where username = 'SOE';
USERNAME ACCOUNT_STATUS CREATED
------------------------------ -------------------- ---------
SOE OPEN 08-MAY-19
查询用户的默认临时表空间
SQL> col default_tablespace for a30
SQL> col temporary_tablespace for a30
SQL> select username,default_tablespace,temporary_tablespace from dba_users where username='SOE';
USERNAME DEFAULT_TABLESPACE TEMPORARY_TABLESPACE
------------------------------ ------------------------------ ------------------------------
SOE SOE TEMP
修改用户的默认表空间
SQL> alter user soe default tablespace soe01;
User altered.
修改用户的临时表空间
SQL> alter user soe temporary tablespace temp01;
User altered.
用户密码过期
SQL> alter user soe password expire;
User altered.
SQL> select username,account_status,created from dba_users where username = 'SOE';
USERNAME ACCOUNT_STATUS CREATED
------------------------------ -------------------- ---------
SOE EXPIRED 08-MAY-19
锁定用户
SQL> alter user soe account lock;
User altered.
SQL> select username,account_status,created from dba_users where username = 'SOE';
USERNAME ACCOUNT_STATUS CREATED
------------------------------ -------------------- ---------
SOE EXPIRED & LOCKED 08-MAY-19
解锁用户
SQL> alter user soe account unlock;
User altered.
SQL> select username,account_status,created from dba_users where username = 'SOE';
USERNAME ACCOUNT_STATUS CREATED
------------------------------ -------------------- ---------
SOE EXPIRED 08-MAY-19
修改用户密码
SQL> alter user soe identified by soe;
User altered.
SQL> select username,account_status,created from dba_users where username = 'SOE';
USERNAME ACCOUNT_STATUS CREATED
------------------------------ -------------------- ---------
SOE OPEN 08-MAY-19
删除用户
SQL> drop user soe cascade;
User dropped.亿速云「云数据库 MySQL」免部署即开即用，比自行安装部署数据库高出1倍以上的性能，双节点冗余防止单节点故障，数据自动定期备份随时恢复。点击查看>>
免责声明：本站发布的内容（图片、视频和文字）以原创、转载和分享为主，文章观点不代表本网站立场，如果涉及侵权请联系站长邮箱：is@yisu.com进行举报，并提供相关证据，一经查实，将立刻删除涉嫌侵权内容。
