首页 > 代码库 > PL/SQL创建用户

PL/SQL创建用户

步骤一:新建

 

步骤二:填写信息

对应SQL代码

-- Create the user create user WENTidentified by "longrise"default tablespace NSESTtemporary tablespace NSEST_TEMPprofile DEFAULT;-- Grant/Revoke object privileges grant read, write on directory SYS.ZWGC to WENT with grant option;-- Grant/Revoke role privileges grant connect to WENT;grant dba to WENT;-- Grant/Revoke system privileges grant unlimited tablespace to WENT;

 

PL/SQL创建用户