Oracle数据库创建用户并且授权
-- Create the user 创建用户(用户名是WPIP,密码是wpip)
create user WPIP identified by wpip
default tablespace PIPDB_DAT1
temporary tablespace TEMP
profile DEFAULT
;
-- Grant/Revoke role privileges (给用户WPIP授予connect ,dba ,resource 权限)
grant connect to WPIP;
grant dba to WPIP;
grant resource to WPIP;
-- Grant/Revoke system privileges (给用户WPIP分配无限的空间)
grant unlimited tablespace to WPIP;
祝:身体健康 工作顺利