创建oracle用户

-----创建用户-----

create user 用户名 identified by 密码; 

-------赋权限-----

grant connect to 用户名;

grant DBA to 用户名;

grant create  any table to 用户名;
grant insert  any table to 用户名;
grant update  any table to 用户名;
grant delete  any table to 用户名;
grant select  any table to 用户名;
grant drop   any table to 用户名;
grant alter  any table to 用户名;
grant under  any table to 用户名;
grant comment any table to 用户名;
grant unlimited tablespace to 用户名;

commit;