Shulou(Shulou.com)06/01 Report--

Create a tablespace

Create tablespace users

Datafile'D:\ Oracle\ oracle\ oradata\ users.dbf'

Size 100m

Autoextend on

Next 100m maxsize 20480m

Extent management local

Create a user

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

Authorization

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

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.