oracle 学习
删除用户,创建用户命令
drop user goda cascade;删除用户及其下所有对象,包括表
CREATE USER qdcenter
IDENTIFIED BY qdcenter
DEFAULT TABLESPACE data1
TEMPORARY TABLESPACE temp1
QUOTA unlimited ON data1
QUOTA unlimited ON temp1
QUOTA unlimited ON idx1
QUOTA unlimited ON rbs1
QUOTA 10M ON system;
GRANT DBA TO qdcenter;
grant create table to qdcenter;
grant insert any table to qdcenter;
grant select any table to qdcenter;
grant update any table to qdcenter;
grant delete any table to qdcenter;
grant create any view to qdcenter;
grant drop any view to qdcenter;
grant alter any sequence to qdcenter;
grant create any sequence to qdcenter;
grant select any sequence to qdcenter;
grant drop any sequence to qdcenter;
grant create public synonym to qdcenter;
grant create any synonym to qdcenter;
grant drop public synonym to qdcenter;
grant drop any synonym to qdcenter;
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步