How to create table spaces, users, and authorizations in Oracle

/*

Before creating a tablespace under the server directory/optoracle/oradata/etld, manually build the Etld directory and use root to give the Etld directory the appropriate permissions, such as 777

*/

--Create a table space

Create Tablespace Tbs_etld_data

Logging

DataFile '/opt/oracle/oradata/etld/etld_data.dbf '

Size 200m

Autoextend on

Next 50m maxsize 1024m

Extent management Local;

Create temporary tablespace tbs_etld_temp

Tempfile '/opt/oracle/oradata/etld/etld_temp.dbf '

Size 100m

Autoextend on

Next 50m maxsize 1024m

Extent management Local;

--Create a user

Create user Etld identified by etld

Default Tablespace tbs_etld_data

Temporary tablespace tbs_etld_temp;

Give the user authorization

Grant connect to Etld;

Grant resource to Etld;

Grant ALTER any index to ETLD;

Grant ALTER any procedure to ETLD;

Grant ALTER any sequence to ETLD;

Grant alter any table to ETLD;

Grant create any context to etld;

Grant Create any index to ETLD;

Grant Create any library to Etld;

Grant create any procedure to etld;

Grant create any table to Etld;

Grant create any type to ETLD;

Grant create any view to Etld;

Grant CREATE procedure to ETLD;

Grant drop any index to ETLD;

Grant drop any library to etld;

Grant execute any operator to ETLD;

Grant execute any procedure to etld;

Grant insert any table to etld;

Grant Select any table to Etld;

Grant unlimited tablespace to Etld;

Grant Debug connect session to Etld;

Grant Select any dictionary to Etld

To this, etld users can use;

This column more highlights: http://www.bianceng.cnhttp://www.bianceng.cn/database/Oracle/