Oracle创建数据库用户语句
注意修改表空间名称,此语句赋予用户的权限比较大。
create user FASP identified by FASP
default tablespace EFMIS
temporary tablespace TEMP
profile DEFAULT
account unlock;
grant connect to FASP with admin option;
grant exp_full_database to FASP;
grant imp_full_database to FASP;
grant javasyspriv to FASP;
grant java_admin to FASP;
grant resource to FASP with admin option;
grant administer database trigger to FASP with admin option;
grant alter any index to FASP;
grant alter any procedure to FASP;
grant