日期:2014-05-16  浏览次数:20385 次

oracle用户授所有权限
grant alter system to linder;
grant audit system to linder;

grant create session to linder;
grant alter session to linder;
grant restricted session to linder;
grant debug connect session to linder;

grant create tablespace to linder;
grant alter tablespace to linder;
grant manage tablespace to linder;
grant drop tablespace to linder;
grant unlimited tablespace to linder;

grant create user to linder;
grant become user to linder;
grant alter user to linder;
grant drop user to linder;

grant create rollback segment to linder;
grant alter rollback segment to linder;
grant drop rollback segment to linder;

grant create table to linder;
grant create any table to linder;
grant alter any table to linder;
grant backup any table to linder;
grant drop any table to linder;
grant lock any table to linder;
grant comment any table to linder;
grant select any table to linder;
grant insert any table to linder;
grant update any table to linder;
grant delete any table to linder;
grant under any table to linder;
grant flashback any table to linder;

grant create cluster to linder;
grant create any cluster to linder;
grant alter any cluster to linder;
grant drop any cluster to linder;

grant create any index to linder;
grant alter any index to linder;
grant drop any index to linder;

grant create synonym to linder;
grant create any synonym to linder;
grant drop any synonym to linder;
grant create public synonym to linder;
grant drop public synonym to linder;

grant create view to linder;
grant create any view to linder;
grant drop any view to linder;
grant under any view to linder;
grant merge any view to linder;
grant drop any materialized view to linder;
grant create materialized view to linder;
grant create any materialized view to linder;
grant alter any materialized view to linder;

grant create sequence to linder;
grant create any sequence to linder;
grant alter any sequence to linder;
grant drop any sequence to linder;
grant select any sequence to linder;

grant create database link to linder;
grant create public database link to linder;
grant drop public database link to linder;
grant alter database to linder;
grant administer database trigger to linder;
grant export full database to linder;
grant import full database to linder;


grant create role to linder;
grant drop any role to linder;
grant grant any role to linder;
grant alter any role to linder;

grant force transaction to linder;
grant force any transaction to linder;
grant select any transaction to linder;

grant create procedure to linder;
grant create any procedure to linder;
grant alter any procedure to linder;
grant drop any procedure to linder;
grant execute any procedure to linder;
grant debug any procedure to linder;

grant create trigger to linder;
grant create any trigger to linder;
grant alter any trigger to linder;
grant drop any trigger to linder;

grant create profile to linder;
grant alter profile to linder;
grant drop profile to linder;
grant drop any sql profile to linder;
grant alter any sql profile to linder;
grant create any sql profile to linder;

grant create type to linder;
grant create any type to linder;
grant alter any type to linder;
grant drop any type to linder;
grant execute any type to linder;
grant under any type to linder;

grant create any directory to linder;
grant drop any directory to linder;

grant create library to linder;
grant create any library to