Oracle Create user

sqlplus /nolog conn sys/pw123456@orcl as sysdba CREATE USER zengwenfeng IDENTIFIED BY zengwenfeng ; GRANT ALL PRIVILEGES TO zengwenfeng ; COMMIT;

C:\Users\Administrator>sqlplus /nolog SQL*Plus: Release 11.2.0.1.0 Production on 星期日 12月 24 21:38:24 2023 Copyright (c) 1982, 2010, Oracle. All rights reserved. SQL> SQL> conn sys/pw123456@orcl as sysdba 已连接。 SQL> SQL> SQL> SQL> CREATE USER zengwenfeng IDENTIFIED BY zengwenfeng; 用户已创建。 SQL> GRANT ALL PRIVILEGES TO zengwenfeng; 授权成功。 SQL> COMMIT; 提交完成。 SQL>

-- 创建用户 CREATE USER zengwenfeng IDENTIFIED BY zengwenfeng; -- 登录必需权限 GRANT CREATE SESSION TO zengwenfeng; -- 允许自建表（自建表可直接创建索引，无需额外授权） GRANT CREATE TABLE TO zengwenfeng; -- 分配表空间配额 ALTER USER zengwenfeng QUOTA UNLIMITED ON USERS; -- 允许创建视图、序列 GRANT CREATE VIEW TO zengwenfeng; GRANT CREATE SEQUENCE TO zengwenfeng;