Oracle 新建用户并附dba权限

-- Create the user
create user glpmpp
identified by "glpmpp"
default tablespace USERS
temporary tablespace TEMP
profile DEFAULT;
-- Grant/Revoke role privileges
grant connect to glpmpp;
grant dba to glpmpp;
grant resource to glpmpp;
-- Grant/Revoke system privileges
grant create any table to glpmpp;
grant unlimited tablespace to glpmpp;

posted @ 2017-09-26 10:17  生锈的大砍刀  阅读(341)  评论(0)    收藏  举报