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...")
 
 
(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;