赋权限给oralce新建的用户

2010年5月13日星期四 

赋权限给oralce新建的用户

grant connect to XX;

grant exp_full_database to XX;

grant imp_full_database to XX;

grant resource to XX;

grant create procedure to XX;

grant create trigger to XX;

grant execute any procedure to XX;

grant grant any privilege to XX;

grant restricted session to XX;

grant select any table to XX;

grant unlimited tablespace to XX;

grant create any view to XX;