oracle 导创建用户,oracle 使用总结 导入 ，导出，创建用户，授权等

1.首先创建用户：

create user joytravcn identified by cn;

create user joytraven identified by en;

create user joytravmember identified by member;

create user joytravadmin identified by admin;

2.给用户授权：

grant dba to CN;

grant unlimited tablespace to CN;

grant select any table to CN;

grant select any dictionary to CN;

grant create session,create table to CN;

grant create sequence to CN;

==================================================

grant dba to EN;

grant unlimited tablespace to EN;

grant select any table to EN;

grant select any dictionary to EN;

grant create session,create table to EN;

grant create sequence to EN;

==================================================

grant dba to MEMBER;

grant unlimited tablespace to MEMBER;

grant select any table to MEMBER;

grant select any dictionary to MEMBER;

grant create session,create table to MEMBER;

grant create sequence to MEMBER;

==================================================

grant dba to ADMIN;

grant unlimited tablespace to ADMIN;

grant select any table to ADMIN;

grant select any dictionary to ADMIN;

grant create session,create table to ADMIN;

grant create sequence to ADMIN;

3.查询用户:

select * from dba_users;

4.删除用户：

drop user admin cascade;

5.到出数据库：

exp file=c:\oracle.dmp owner=(CN,EN,MEMBER,ADMIN);

或：

exp system/admin full=y file=d:\oraclebackups\oracle.dmp log=d:\oraclebackups\oracle.log

6.倒入数据库：

imp system/admin@127.0.0.1:1521/XE file=d:\oracle.dmp FULL=Y;