--创建用户
create user tzb111 identified by tzb111 ;
--赋予权限
grant connect,resource to tangzhanbo;
grant dba to tangzhanbo;
--查看用户所属表空间
select username,default_tablespace from dba_users where username='SYS';
select username,default_tablespace from dba_users where username='TANGZHANBO';
--查询表所属的用户 需dba权限
select owner from dba_tables where table_name='SYS_DEPT';
--删除一张表
drop table sys_dept;