/创建普通用户/
create user nmg1500 identified by pwd_oracle;
/删除用户/
drop user konglin;
/授予用户登录数据库的权限:/
grant create session to konglin;
/* 授予用户操作表空间的权限:*/
grant unlimited tablespace to nmg1500;
grant create tablespace to nmg1500;
grant alter tablespace to nmg1500;
grant drop tablespace to nmg1500;
grant manage tablespace to nmg1500;
/* 授予用户操作表的权限:(包含有create index权限, alter table, drop table权限)*/
grant create table to nmg1500;
/* 授予用户操作视图的权限:(包含有alter view, drop view权限)*/
grant create view to nmg1500;
/* 授予用户操作触发器的权限: (包含有alter trigger, drop trigger权限)*/
grant create trigger to nmg1500;
/* 授予用户操作存储过程的权限:(包含有alter procedure, drop procedure 和function 以及 package权限)*/
grant create procedure to nmg1500;
/* 授予用户操作序列的权限:(包含有创建、修改、删除以及选择序列)*/
grant create sequence to nmg1500;
grant create view to nmg1500;
/* 授予用户回退段权限:*/
grant create rollback segment to nmg1500;
grant alter rollback segment to nmg1500;
grant drop rollback segment to nmg1500;
/* 授予用户同义词权限:(包含drop synonym权限)*/
grant create synonym to nmg1500;
grant create public synonym to nmg1500;
grant drop public synonym to nmg1500;
/* 授予用户关于用户的权限:*/
grant create user to nmg1500;
grant alter user to nmg1500;
grant become user to nmg1500;
grant drop user to nmg1500;
/* 授予用户操作概要文件的权限*/
grant create profile to nmg1500;
grant alter profile to nmg1500;
grant drop profile to nmg1500;