oracle创建表空间和用户授权

发布时间：2020-08-02 11:55:28 来源：网络阅读：242 作者：laiwenhuajava 栏目：关系型数据库

创建表空间

create tablespace users
datafile 'D:\Oracle\oracle\oradata\users.dbf'
size 100m
autoextend on
next 100m maxsize 20480m
extent management local;

创建用户

create user hy_pubres identified by 123;

            grant create session to hy_pubres;
            grant create table to hy_pubres;
            grant create tablespace to hy_pubres;
            grant create view to hy_pubres;
  授权
            alter user hy_pubres quota unlimited on icity;

            alter user hy_pubres quota unlimited on users;

grant create job to HY_PUBRES;
grant create procedure to HY_PUBRES;
grant create sequence to HY_PUBRES;
grant create session to HY_PUBRES;
grant create table to HY_PUBRES;
grant create tablespace to HY_PUBRES;
grant create trigger to HY_PUBRES;
grant create view to HY_PUBRES;

向AI问一下细节

oracle创建表空间和用户授权

猜你喜欢

最新资讯

相关推荐

相关标签