Steps:
1. Create a temporary table space
Create temporary tablespace cindex_temp tempfile '/u01/oracle/app/oradata/mytablespace/cindex_temp.dbf ' size 1024m Autoextend on next 100m maxsize 10240m extent management local;
2. Create a table space
Create tablespace cindex logging datafile '/u01/oracle/app/oradata/mytablespace/cindex dbf ' size 1024m autoextend on next 100m MaxSize 10240m extent management local;
3. Create a user and specify a tablespace
Create user ABC identified by ABC default tablespace ABC temporary tablespace cindex_temp;
4. Create roles and assign permissions to roles
CREATE ROLE R_insert;
CREATE ROLE R_delete;
CREATE ROLE r_update;
CREATE ROLE R_delete;
Grant INSERT on SFIS1. c_product_t to R_insert;
Grant DELETE on SFIS1. c_product_t to R_delete;
Grant UPDATE on SFIS1. c_product_t to R_update;
Grant DELETE on SFIS1. c_product_t to R_delete;
5. Giving the role authorization
Grant INSERT on SFIS1. c_product_t to R_insert;
Grant DELETE on SFIS1. c_product_t to R_delete;
Grant UPDATE on SFIS1. c_product_t to R_update;
Grant DELETE on SFIS1. c_product_t to R_delete;
6. Assigning Roles to users
GRANT R_insert,r_delete,r_update,r_delete to Sfis1;
Some statements used by DBAs