oracle权限

sqlplus / as sysdba 
grant create any index to scott 授予创建任何索引
grant create procedure to scott 授予创建储存过程
grant create sequence to scott 授予创建序列
grant create synonym to scott 授予创建同义词
grant create trigger to scott 授予创建触发器
grant create type to scott 授予创建自定义类型
grant create view to scott 授予创建视图
grant unlimited tablespace to scott 授予使用表空间的权限

　　

转载于:https://www.cnblogs.com/nbkyzms/p/5031445.html