oracle创建用户表空间

最新推荐文章于 2021-12-15 00:11:47 发布

守护的玉

最新推荐文章于 2021-12-15 00:11:47 发布

阅读量367

点赞数

CC 4.0 BY-SA版权

分类专栏： oracle

本文链接：https://blog.youkuaiyun.com/li951383937/article/details/52512586

oracle 专栏收录该内容

8 篇文章

订阅专栏

本文介绍如何在Oracle数据库中创建用户CQ_TTEST，并设置密码为111111，指定默认表空间和临时表空间。此外，还详细列出了授予该用户的各项系统权限，包括ALTER USER、CREATE ANY SYNONYM等。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

drop user CQ_TTEST cascade;

create user CQ_TTEST
  identified by "111111"
  default tablespace SYSTEM
  temporary tablespace TEMP
  profile DEFAULT
  password expire
  quota unlimited on SYSTEM
  quota unlimited on SYSTEM
  quota unlimited on users;
-- Grant/Revoke system privileges
grant alter user to CQ_TTEST with admin option;
grant create any synonym to CQ_TTEST with admin option;
grant create materialized view to CQ_TTEST with admin option;
grant create procedure to CQ_TTEST with admin option;
grant create public synonym to CQ_TTEST with admin option;
grant create sequence to CQ_TTEST with admin option;
grant create session to CQ_TTEST with admin option;
grant create table to CQ_TTEST with admin option;
grant create trigger to CQ_TTEST with admin option;
grant create user to CQ_TTEST with admin option;
grant create view to CQ_TTEST with admin option;
grant drop public synonym to CQ_TTEST with admin option;
grant drop user to CQ_TTEST with admin option;
grant dba to CQ_TTEST;

里面的CQ_TTEST是用户 identified by "111111"是密码