用户

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 改动用户password
 alter user cbpdb1 identified by cbpdb1;

1.用户的创建
create user etl
identified by "etl"
default tablespace tbs_etl_system
temporary tablespace tbs_etl_temp
profile default;

grant connect , resource , create any view , drop any view to etl;

grant unlimited tablespace to etl;
----------------------------------------------------------------------------------
--建立lbidw_ym_mobile、lbimk_ym_mobile、lbikr_ym_mobile三个用户(password须要更改)
----------------------------------------------------------------------------------
-- Create lbidw_ym_mobile user
create user lbidw_ym_mobile
  identified by "lbidw_ym_mobile"
  default tablespace TBS_DW_YM
  temporary tablespace TBS_YM_TEMP
  profile DEFAULT;

-- Grant/Revoke role privileges
grant connect to lbidw_ym_mobile;
grant dba to lbidw_ym_mobile;
grant resource to lbidw_ym_mobile;
-- Grant/Revoke system privileges
grant alter any index to lbidw_ym_mobile;
grant alter any sequence to lbidw_ym_mobile;
grant alter any table to lbidw_ym_mobile;
grant alter any procedure to lbidw_ym_mobile;
grant alter tablespace to lbidw_ym_mobile;
grant create any context to lbidw_ym_mobile;
grant create any index to lbidw_ym_mobile;
grant create any library to lbidw_ym_mobile;
grant create any procedure to lbidw_ym_mobile;
grant create any table to lbidw_ym_mobile;
grant create any type to lbidw_ym_mobile;
grant create any view to lbidw_ym_mobile;
grant create procedure to lbidw_ym_mobile;
grant create public database link to lbidw_ym_mobile;
grant drop any index to lbidw_ym_mobile;
grant drop any library to lbidw_ym_mobile;
grant drop public database link to lbidw_ym_mobile;
grant execute any operator to lbidw_ym_mobile;
grant execute any procedure to lbidw_ym_mobile;
grant insert any table to lbidw_ym_mobile;
grant select any table to lbidw_ym_mobile;
grant select any dictionary to lbidw_ym_mobile;
grant unlimited tablespace to lbidw_ym_mobile;