最近一直做数据库迁移,找了很多资料终于找到个全的了,在此记录一下
1.采用sys or system / manager as sysdba; 连接数据库。
2. 创建普通用户enis,密码123123: create user enis identified by 123123;
删除用户, drop user enis;
3. 授予用户登录数据库的权限: grant create session to enis;
4. 授予用户操作表空间的权限:
grant unlimited tablespace to enis;
grant create tablespace to enis;
grant alter tablespace to enis;
grant drop tablespace to enis;
grant manage tablespace to enis;
5. 授予用户操作表的权限:
grant create table to enis; (包含有create index权限, alter table, drop table权限)
6. 授予用户操作视图的权限:
grant create view to enis; (包含有alter view, drop view权限)
7. 授予用户操作触发器的权限:
grant create trigger to enis; (包含有alter trigger, drop trigger权限)
8. 授予用户操作存储过程的权限:
grant create procedure to enis;(包含有alter procedure, drop procedure 和function 以及 package权限)
9. 授予用户操作序列的权限:
grant create sequence to enis; (包含有创建、修改、删除以及选择序列)
10. 授予用户回退段权限:
grant create rollback segment to enis;
grant alter rollback segment to enis;
grant drop rollback segment to enis;
11. 授予用户同义词权限:
grant create synonym to enis;(包含drop synonym权限)
grant create public synonym to enis;
grant drop public synonym to enis;
12. 授予用户关于用户的权限:
grant create user to enis;
grant alter user to enis;
grant become user to enis;
grant drop user to enis;
13. 授予用户关于角色的权限:
grant create role to enis;
14. 授予用户操作概要文件的权限
grant create profile to enis;
grant alter profile to enis;
grant drop profile to enis;
15. 允许从sys用户所拥有的数据字典表中进行选择
grant select any dictionary to enis;
转自:http://blog.csdn.net/csh602583095/article/details/35875779