Difference between revisions of "More details for creating user"
Jump to navigation
Jump to search
(Created page with "alter session set "_ORACLE_SCRIPT"=true; drop user SMARTHCM_ABC cascade; -- Create the user create user SMARTHCM_ABC identified by SMARTHCM_ABC default tablespace SMART...") |
|||
| (One intermediate revision by the same user not shown) | |||
| Line 1: | Line 1: | ||
| + | <pre> | ||
| + | |||
alter session set "_ORACLE_SCRIPT"=true; | alter session set "_ORACLE_SCRIPT"=true; | ||
drop user SMARTHCM_ABC cascade; | drop user SMARTHCM_ABC cascade; | ||
| Line 23: | Line 25: | ||
grant unlimited tablespace to SMARTHCM_ABC; | grant unlimited tablespace to SMARTHCM_ABC; | ||
grant unlimited tablespace to SMARTHCM_ABC; | grant unlimited tablespace to SMARTHCM_ABC; | ||
| + | |||
| + | </pre> | ||
Latest revision as of 12:49, 9 January 2019
alter session set "_ORACLE_SCRIPT"=true; drop user SMARTHCM_ABC cascade; -- Create the user create user SMARTHCM_ABC identified by SMARTHCM_ABC default tablespace SMARTHCM temporary tablespace TEMP profile DEFAULT password expire; -- Grant/Revoke role privileges grant connect to SMARTHCM_ABC; grant dba to SMARTHCM_ABC; grant dba to SMARTHCM_ABC; grant resource to SMARTHCM_ABC; -- Grant/Revoke system privileges grant create any directory to SMARTHCM_ABC; grant create any job to SMARTHCM_ABC; grant create materialized view to SMARTHCM_ABC; grant create synonym to SMARTHCM_ABC; grant create table to SMARTHCM_ABC; grant create view to SMARTHCM_ABC; grant debug connect session to SMARTHCM_ABC; grant unlimited tablespace to SMARTHCM_ABC; grant unlimited tablespace to SMARTHCM_ABC;
