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;