菜单 学习猿地 - LMONKEY

VIP

开通学习猿地VIP

尊享10项VIP特权 持续新增

知识通关挑战

打卡带练!告别无效练习

接私单赚外块

VIP优先接,累计金额超百万

学习猿地私房课免费学

大厂实战课仅对VIP开放

你的一对一导师

每月可免费咨询大牛30次

领取更多软件工程师实用特权

入驻
499
0

oracle 学习

原创
05/13 14:22
阅读数 549424

标签:div   c   t   sp   tab   ble   table   user   view   rac   date   

删除用户,创建用户命令

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;

oracle 学习,布布扣,bubuko.com

oracle 学习

发表评论

0/200
499 点赞
0 评论
收藏
为你推荐 换一批