站点图标 IDC铺

如何在oracle pl/sql 中创建用户,详情操作教程方法

模式:
create user 用户名
default tablespace 表空间名;
举例:
— Create the user
create user ACCOUNT
identified by “”
default tablespace ACCOUNTTS
temporary tablespace TEMP
profile DEFAULT;
— Grant/Revoke role privileges
grant connect to ACCOUNT;
grant resource to ACCOUNT;
— Grant/Revoke system privileges
grant unlimited tablespace to ACCOUNT;

退出移动版