1 删除用户 drop user BILLINGDB cascade; 2 创建用户 CREATE USER BILLINGDB IDENTIFIED BY BILLINGDB DEFAULT TABLESPACE XXXX TEMPORARY TABLESPACE TEMPXXX; GRANT CONNECT, RESOURCE, DBA TO BILLINGDB; select 'grant select on '||owner||'.'||object
1 删除用户
drop user BILLINGDB cascade;
2 创建用户
CREATE USER BILLINGDB IDENTIFIED BY BILLINGDB DEFAULT TABLESPACE XXXX TEMPORARY TABLESPACE TEMPXXX;
GRANT CONNECT, RESOURCE, DBA TO BILLINGDB;
select 'grant select on '||owner||'.'||object_name|| ' to user'
from dba_objects
where object_type='TABLE' and owner='USERDB';
3 查看用户当前存在的会话session
select s.sid, s.serial# from v$session s where upper(username)=upper('billingdb');
4 修改用户密码
alter user cbpdb1 identified by cbpdb1;
已抢66207个
抢已抢35051个
抢已抢19510个
抢