数据库用户

创建用户

创建用户需要指派权限
SQL> create user tester identified by 123456;
create user tester identified by 123456
ORA-01031: 权限不足

CREATE USER 用户名 IDENTIFIED BY 密码
SQL> create user tester identified by 123456;
User created

创建用户并设置默认表空间及临时表空间
SQL> create user tester identified by 123456 default tablespace system temporary tablespace temp;
User created

删除用户

SQL> drop user tester;
User dropped

删除用户及用户下所有对象
SQL> drop user bjsxt cascade;
User dropped