建立用户: grant dba,connect,resource to user1 identified by password; 表空间修改: alter user user1 default tablespace tb1 temporary tablespace tb2; 用户删除: drop user user1 cascade;
grant dba to test identified by test; grant select any table to test identified by test; drop user test;
1.grant dba to 用户名 identified by 密码 2.drop user 用户名
grant dba,connect,resource to user1 identified by password;
表空间修改:
alter user user1 default tablespace tb1 temporary tablespace tb2;
用户删除:
drop user user1 cascade;
grant select any table to test identified by test;
drop user test;
2.drop user 用户名