Oracle Create user

sqlplus /nolog conn sys/pw123456orcl as sysdba CREATE USER zengwenfeng IDENTIFIED BY zengwenfeng ; GRANT ALL PRIVILEGES TO zengwenfeng ; COMMIT;C:\Users\Administratorsqlplus /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/pw123456orcl 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;