用plsql登陆oracle,创建用户赋予权限

create user GPS110 identified by "gps11012345";

grant connect,dba to GPS110;

grant exp_full_database,imp_full_database,resource,create any sequence to GPS110;

grant create any trigger,create any view,create table,drop any view to GPS110;

grant exp_full_database,imp_full_database,resource,create any sequence to GPS110;

grant select any table to GPS110;

posted @ 2010-03-03 15:32  googlegis  阅读(459)  评论(0)    收藏  举报

坐标合肥,非典型GIS开发人员 GitHub