创建用户:
create user uaername identified by password default tablespace '表空间' temporary tablespace temp;
删除用户:
drop user username cascade;
赋权限:
GRANT CREATE USER,DROP USER,ALTER USER ,CREATE ANY VIEW , DROP ANY VIEW,EXP_FULL_DATABASE,IMP_FULL_DATABASE,DBA,
CONNECT,RESOURCE,CREATE SESSION TO username; -------- 给用户权限
查看用户状态
select username,account_status from dba_users where username='test';
解锁:
ALTER USER YS_ADM ACCOUNT UNLOCK;
select count(*) from user_tables