Создание пользователя в БД ORACLE

-- Шаг 1. Поменять поле [USER] и [PASSWORD] create user [USER]   identified by [PASSWORD]   default tablespace USERS   temporary tablespace TEMP   quota unlimited on sysaux   quota unlimited on system   quota unlimited on users   profile DEFAULT; -- Grant/Revoke role privileges  grant connect to [USER]; grant resource, ctxapp to [USER]; grant imp_full_database to [USER]; -- Grant/Revoke system privileges  grant create procedure to [USER]; grant create sequence to [USER]; grant create synonym to [USER]; grant create table to [USER]; grant create trigger to [USER]; grant create type to [USER]; grant create view to [USER]; grant alter system to [USER]; grant alter session to [USER]; grant debug any procedure to [USER]; grant debug connect session to [USER]; -- Grant/Revoke objects grant select on sys.v_$lock to [USER]; grant execute on SYS.DBMS_LOGMNR to [USER]; grant execute on SYS.DBMS_PROFILER to [USER]; grant select on SYS.V_$LOGMNR_CONTENTS to [USER]; grant select on SYS.V_$MYSTAT to [USER]; grant select on SYS.V_$LOGFILE to [USER]; grant select on SYS.V_$OPEN_CURSOR to [USER]; grant select on SYS.V_$SESSION to [USER]; grant select on SYS.V_$PROCESS to [USER]; grant select on SYS.DBMS_LOCK_ALLOCATED to [USER]; -- Grant/Revoke Java privileges call dbms_java.grant_permission( UPPER('[USER]'), 'SYS:java.io.FilePermission', '<<ALL FILES>>', 'execute' ); call dbms_java.grant_permission( UPPER('[USER]'), 'SYS:java.io.FilePermission', '<<ALL FILES>>', 'write' ); call dbms_java.grant_permission( UPPER('[USER]'), 'SYS:java.io.FilePermission', '<<ALL FILES>>', 'read' ); call dbms_java.grant_permission( UPPER('[USER]'), 'SYS:java.lang.RuntimePermission', 'writeFileDescriptor', '' ); call dbms_java.grant_permission( UPPER('[USER]'), 'SYS:java.lang.RuntimePermission', 'readFileDescriptor', '' ); call dbms_java.grant_permission(UPPER('[USER]'), 'SYS:java.net.SocketPermission', '*', 'accept,connect,listen,resolve'); 

 grant execute on SYS.DBMS_BACKUP_RESTORE to [USER]; grant select on SYS.XKRBMSFT to [USER]; 

 -- Job Privileges grant all on sys.dbms_job to [USER]; grant all on sys.dba_jobs to [USER]; grant all on sys.dba_jobs_running to [USER]; grant execute on sys.dbms_lock to [USER]; grant all on sys.DBMS_CRYPTO to [USER]; 

 

 ---Шаг2. Создание директора для XML импортов. Заменить [UTL_DIR] create or replace directory UTL_FILE_DIR as '[UTL_DIR]'; grant all on directory UTL_FILE_DIR to [USER]; 

 -- шаг 3 Для BACKUP create or replace directory backup as '[BACKUP_DIR]'; grant all on directory backup to [USER]; 

 

 -- шаг 4. Импортировать схему carabi (в директории [BACKUP_DIR] должен лежать архив sirop.dmp.gz  ) gzip -d carabi7.dmp.gz  impdp system/systempassw0rd@orcl remap_schema=carabi7:[USER] directory=BACKUP dumpfile=carabi7.dmp logfile=[USER].log TABLE_EXISTS_ACTION=REPLACE