创建数据库用户

create user FASPPT_150005 identified by 1

default tablespace EFMIS

temporary tablespace TEMP

profile DEFAULT;

-- Grant/Revoke role privileges 

grant connect to FASPPT_150005 with admin option;

grant dba to FASPPT_150005;

grant exp_full_database to FASPPT_150005;

grant imp_full_database to FASPPT_150005;

grant javasyspriv to FASPPT_150005;

grant java_admin to FASPPT_150005;

grant resource to FASPPT_150005 with admin option;

-- Grant/Revoke system privileges 

grant administer database trigger to FASPPT_150005 with admin option;

grant alter any procedure to FASPPT_150005;

grant alter any table to FASPPT_150005;

grant comment any table to FASPPT_150005;

grant create any materialized view to FASPPT_150005 with admin option;

grant create any procedure to FASPPT_150005;

grant create any sequence to FASPPT_150005;

grant create any synonym to FASPPT_150005 with admin option;

grant create any table to FASPPT_150005 with admin option;

grant create any trigger to FASPPT_150005;

grant create any view to FASPPT_150005 with admin option;

grant create database link to FASPPT_150005;

grant create job to FASPPT_150005;

grant create materialized view to FASPPT_150005;

grant create procedure to FASPPT_150005;

grant create sequence to FASPPT_150005;

grant create session to FASPPT_150005;

grant create synonym to FASPPT_150005;

grant create table to FASPPT_150005;

grant create trigger to FASPPT_150005;

grant create type to FASPPT_150005;

grant create view to FASPPT_150005;

grant debug any procedure to FASPPT_150005;

grant debug connect session to FASPPT_150005;

grant delete any table to FASPPT_150005 with admin option;

grant drop any materialized view to FASPPT_150005;

grant drop any synonym to FASPPT_150005 with admin option;

grant drop any table to FASPPT_150005;

grant drop any view to FASPPT_150005;

grant insert any table to FASPPT_150005 with admin option;

grant select any dictionary to FASPPT_150005;

grant select any table to FASPPT_150005 with admin option;

grant unlimited tablespace to FASPPT_150005 with admin option;

grant update any table to FASPPT_150005 with admin option;

创建数据库用户

原文：http://blog.51cto.com/13693838/2103143