Difference between revisions of "More details for creating user"
(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;