Difference between revisions of "More details for creating user"

From SmartHCM Wiki
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...")
 
Line 1: Line 1:
alter session set "_ORACLE_SCRIPT"=true;   
+
<nowiki>alter session set "_ORACLE_SCRIPT"=true;   
 
drop user SMARTHCM_ABC cascade;
 
drop user SMARTHCM_ABC cascade;
 
-- Create the user  
 
-- Create the user  
Line 22: Line 22:
 
grant debug connect session to SMARTHCM_ABC;
 
grant debug connect session to SMARTHCM_ABC;
 
grant unlimited tablespace to SMARTHCM_ABC;
 
grant unlimited tablespace to SMARTHCM_ABC;
grant unlimited tablespace to SMARTHCM_ABC;
+
grant unlimited tablespace to SMARTHCM_ABC;</nowiki>

Revision as of 12:47, 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;