当前位置：网站首页>oracle tablespace and user creation

oracle tablespace and user creation

2022-08-11 05:17:00 【weixin_47088026】

Tablespace and user creation

create tablespace spaceName(Tablespace)datafile 'D:/app/Administrator/oradata/orcl/EINVOICEDATA.dbf' size 128m autoextend on next 100m;-- Create the user create user userName(username)identified by password(password)default tablespace userName(username)temporary tablespace TEMP;-- Grant/Revoke role privileges grant connect to userName(username);grant dba to userName(username);GRANT SELECT ANY TABLE TO userName(username) WITH ADMIN OPTION;