新建用户、付权限命令

删除已有用户及与用户相关的

drop user usernam cascade; 

以DBA登录
sqlplus sys/gis@lxgh as sysdba

创建表空间
create tablespace work datafile 'E:\ghoa\ldghTableSpace\work.dbf' size 400m autoextend on next 20m online;

创建新用户

create user work identified by work;

给新建用户付 权限

Alter user  work   default tablespace work quota unlimited on work;
grant create session to work;

grant connect, resource, dba to work;
grant create table to work;
grant create view to work;
grant create trigger to work;
grant select any table to work;
grant create sequence to work;
grant create procedure to work;
grant create role to work;
grant create type to work;
grant GRANT ANY PRIVILEGE to work;