Home
Search results “Grant directory oracle”
how to create directory in oracle 12c, 11g
 
02:52
Use the CREATE DIRECTORY statement to create a directory object. A directory object specifies an alias for a directory on the server file system where external binary file LOBs and external table data are located. You can use directory names when referring to BFILEs in your PL/SQL code and OCI calls, rather than hard coding the operating system path name, for management flexibility. All directories are created in a single namespace and are not owned by an individual schema. You can secure access to the BFILEs stored within the directory structure by granting object privileges on the directories to specific users. You must have CREATE ANY DIRECTORY system privilege to create directories. When you create a directory, you are automatically granted the READ and WRITE object privileges on the directory, and you can grant these privileges to other users and roles. The DBA can also grant these privileges to other users and roles. WRITE privileges on a directory are useful in connection with external tables. They let the grantee determine whether the external table agent can write a log file or a bad file to the directory. For file storage, you must also create a corresponding operating system directory, an ASM disk group, or a directory within an ASM disk group. Your system or database administrator must ensure that the operating system directory has the correct read and write permissions for Oracle Database processes. Privileges granted for the directory are created independently of the permissions defined for the operating system directory, and the two may or may not correspond exactly. For example, an error occurs if sample user hr is granted READ privilege on the directory object but the corresponding operating system directory does not have READ permission defined for Oracle Database processes. ---------------------------------------------------------------------------- Default directory is DATA_PUMP_DIR.Below command is to get directory name and directory path. SELECT directory_name, directory_path FROM dba_directories WHERE directory_name='DATA_PUMP_DIR' DIRECTORY_NAME DIRECTORY_PATH --------------- ------------------------------------------------------- DATA_PUMP_DIR /u01/app/mohammad75/product/12.1.0/dbhome_1/rdbms/log/
Views: 2012 Oracle DBA World
How to create an user and to grant all privileges to them in Oracle database
 
03:52
This video shows you how to create a new user and to grant privileges to them. Syntax to create a new user: create user username identified by password
Views: 33719 Thamizh arasaN
Oracle Export Data and Import Data using DataPump
 
20:22
Steps to Import and Export Table Step 1: Create Directory Step 2: Grant Read and Write Permission to Directory Step 3: GRANT ROLL DATAPUMP_EXP_FULL_DATABASE to user Step 04: Use EXPDP and IMPDP to Export and Import data
Views: 4900 Data Science Center
Create user, connection, role and grant, evoke permission in Oracle 11g
 
05:58
This video will show you: - How to create user - How to create role - How to create new connection - How to grant permission to user/role - How to grant role to user - How to revoke permission
Views: 1232 Progtips 4 Devs
Часть 0. Oracle Database. Установка Oracle Linux 7 1 в Virtual Box и установка Oracle XE
 
01:10:53
Видео-мануал по установке Oracle Linux в VirtualBox и установка Oracle XE. Содержимое файлов настроек и скрипты: Содержимое файла .bash_profile. Открываем: nano /root/.bash_profile Вставляем: #Oracle install specific environment settings umask 022 TMP=/tmp; export TMP TMPDIR=$TMP; export TMPDIR ORACLE_HOSTNAME=localhost.localdomain; export ORACLE_HOSTNAME ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe; export ORACLE_HOME ORACLE_SID=orcl; export ORACLE_SID ORACLE_TERM=xterm; export ORACLE_TERM PATH=$ORACLE_HOME/bin:/usr/sbin:$PATH; export PATH LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH CLASSPATH=$CLASSPATH:$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH NLS_LANG=AMERICAN_AMERICA.CL8MSWIN1251; export NLS_LANG Ctrl+O сохранить, Ctrl+X выйти из nano. В mc - F4 редактировать файл, F2 - сохранить, F10 выйти Открываем порт 1521 и 8080 в Firewall на Oracle Linux 7.1: firewall-cmd --zone=public --add-port=1521/tcp --permanent ; firewall-cmd --zone=public --add-port=8080/tcp --permanent ; firewall-cmd --reload ; firewall-cmd --zone=public --list-ports Должно быть так: success success success 1521/tcp 8080/tcp Команды создания пользователя вставляем в SQL Navigator или SQL Developer: --DROP USER analytic CASCADE; --Это удаление пользователя и всех его данных. CREATE USER analytic IDENTIFIED BY 123456; --123456 - это пароль. GRANT CREATE SESSION TO analytic; --право подключаться. Ѕез него невозможно залогиниться в Oracle --под этим пользователем. GRANT CREATE TABLE TO analytic; --право создавать таблицы GRANT CREATE PROCEDURE TO analytic; --право создавать процедуры GRANT CREATE TRIGGER TO analytic; --право создавать триггеры GRANT CREATE VIEW TO analytic; --право создавать представления GRANT CREATE SEQUENCE TO analytic; --право создавать последовательности GRANT CREATE LIBRARY TO analytic; --право создавать внешние процедуры/библиотеки GRANT CREATE ANY DIRECTORY TO analytic; GRANT DROP ANY DIRECTORY TO analytic; --право создавать, удалять, читать и писать в директории GRANT CREATE PUBLIC SYNONYM TO analytic; GRANT EXECUTE ON SYS.UTL_HTTP TO analytic; GRANT EXECUTE ON SYS.UTL_FILE TO analytic; GRANT EXECUTE ON SYS.utl_smtp TO analytic; GRANT EXECUTE ON SYS.utl_xml TO analytic; --права на использование пакетов ALTER USER analytic QUOTA UNLIMITED ON USERS; ALTER USER analytic QUOTA UNLIMITED ON SYSTEM; --раздаем квоты на использование места - неограничено. COMMIT; --подтверждение сделанных в данной сессии операций Access Control List не могу опубликовать, с видео тащите. Гугл не позволяет писать скобки в описании видео. Но в принципе ACL и не нужен большинству из вас.
Adding users, groups and creating directories for oracle database and  oracle software
 
02:30
above video shows how to add new users, groups to the system and create directories for installation of oracle database 12c software. It also shows how to grant permissions of a directory to a specific user who would be installing the software.
Views: 1418 dbaforbeginners
oracle tutorial for beginners in hindi | export and import in oracle 11g with examples
 
19:02
In this video you can learn how to take backup with new users . you need to provide the authentication to new user through sys user . by using grant you can provide the access . you need to provide access on directory also using expdp directory = name dumpfile =name logfile =name schemas =user name full=y tables=user name.table name
Views: 1163 Bharat Arya
ORA-01031 insufficient privileges  -- Windows OS
 
02:21
when you connect to oracle database trhrouout sqlplus as sysdba by the command line (CMD) on Windows OS some times you face that you cannot connect to oracle due to oracle error OR- 01031.
Views: 37308 Abdulhakim Desuki
1_2 Create user & Home Directory for Oracle
 
07:38
create oracle user and home directory for the installation of Oracle 11g R2 on Redhat Enterprise Linux 7
Views: 202 Rinku Kumar Singh
63/125 Oracle PLSQL: Supplied  Packages / UTL_FILE  2
 
11:58
if you face issue remember to do this grant READ, WRITE on DIRECTORY MYDIR to public; تعلم اوراكل حتى الاحتراف Learn Oracle PLSQL EXAM 1Z0-144
Views: 530 khaled alkhudari
Role Based Access Control
 
04:50
This video is part of the Udacity course "Intro to Information Security". Watch the full course at https://www.udacity.com/course/ud459
Views: 50521 Udacity
Gerar backup lógico expdp DATAPUMP oracle
 
07:45
--EXPDP -- DATAPUMP select * from dba_directories; CREATE OR REPLACE DIRECTORY DUMP AS '/oracle_files/dump'; GRANT READ, WRITE ON DIRECTORY DUMP TO scott; GRANT EXP_FULL_DATABASE to scott; -- Full Export expdp scott/tiger DIRECTORY=DUMP DUMPFILE=expdp_full.dmp FULL=y LOGFILE=expdp_full.log -- schema Export expdp scott/tiger DIRECTORY=DUMP DUMPFILE=exp_scott.dmp schemas=scott LOGFILE=exp_scott.log -- Table Export expdp scott/tiger tables=EMP directory=DUMP DUMPFILE=EMP_DUMP.dmp logfile=EMP_DUMP.log -- Compactado ExpDP expdp scott/tiger DIRECTORY=DUMP DUMPFILE=exp_scott.dmp schemas=scott LOGFILE=exp_scott.log compression=all
Views: 101 Vídeos Aulas TI
Oracle Workflow 06 Components Directory Service
 
25:44
This Video discusses Directory Service Tables and Views that contain Roles data and Users assigned to these Roles
Views: 449 Tarek Saleh
SQL tutorial 48: How to create Roles in Oracle Database
 
07:16
4th SQL Tutorial in the series of user privileges in oracle database user Roles in Oracle Database. In this tutorial you will learn ● What user roles ● How to create simple roles (Role with Not Identified clause) ● How to create secure roles (Role with Identified clause) ● How to create external role. ● How To create global role. ● How to Grant System Privilege to a user Role ● How to Grant Object Privilege to a user Role In oracle database. ● How to grant a Role to another Role ● How To grant a role to database users (with Admin option) ● How To enable role using SET ROLE statement This video will teach you the concept of user role in oracle database which is an extension to the user privileges. In this video I did 10 SQL queries on user Roles which makes this tutorial fun. Celebrating 1000 subscribers. Thanks a lot guys for all your love and support. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/create_role_in_oracle System Privilege: http://youtu.be/EQzdtKPiErU Object Privilege: http://youtu.be/DuDL7NTPdqQ ------------------------------------------------------------------------- Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=kb4rc1 -------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the first one to see my videos! -------------------------------------------------------------------------- Amazon Wishlist: http://bit.ly/wishlist-amazon ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider https://www.facebook.com/imthebhardwaj http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ http://rebellionrider.tumblr.com/ http://www.pinterest.com/rebellionrider/ You can also Email me at [email protected] Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 22578 Manish Sharma
How to solve insufficient privileges in oracle and create a new user
 
03:09
This video is about how to solve the error insufficient privileges in oracle and how to create a new user in oracle......... You can use this method for sql developer. After opening sql developer go to command prompt and follow this instruction .... I hope this will help you for solving the insufficient privileges in oracle 10g...... -------------------------------------------------------------------------------- If face any problem then .. Contact/Follow on........ Email : [email protected] Google+ : https://plus.google.com/102074100342156490577 Twitter : https://twitter.com/Alamgir21409730 Facebook : https://www.facebook.com/computersoftwaresolution/ Subscribe this youtube channel : https://www.youtube.com/channel/UCkE_J-tXiqxzASO6nlB8D6w
Views: 5728 Education Help
Oracle DB - User Management
 
07:14
Oracle DB - User Management Watch More Videos at: https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Parth Panjabi, Tutorials Point India Private Limited
SQL, Oracle Roles and Privileges, 2e56
 
06:00
Video will discuss application of roles in Oracle envirnonment and use of some important SQL statements associated with it.
Views: 1243 hammadshams
Oracle DBA Justin - How to setup a database user to be identified externally with os authentication
 
14:10
How to setup a database user to be identified externally with os authentication
Views: 4996 jbleistein11
Sysdba privilege in Oracle   | Operating System Authentication in Oracle | Oracle  DBA Videos
 
51:13
This video is the part of "Oracle Database Administration Made Simple" Series. This video discuss about the following -- Discussion on database authentication -- Discussion on OS ( operating System) authentication -- Sysdba privilege
How to Add a User and Grant Root Privileges on CentOS 7
 
03:21
How to Add a User and Grant Root Privileges on CentOS 7 and redhat linux
Views: 14453 Quick Notepad Tutorial
Oracle DB - Privilege
 
11:50
Oracle DB - Privilege Watch More Videos at: https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Parth Panjabi, Tutorials Point India Private Limited
Oracle DBA Justin - How to set the Oracle environment on a Unix or Linux system
 
28:22
How to set the Oracle environment on a Unix or Linux system
Views: 46574 jbleistein11
Oracle SQL Developer Tutorial For Beginners   50   DCL   System Privileges
 
00:30
Oracle SQL Developer Tutorial For Beginners Series. This course introduces Oracle SQL Development for its subscribers. Currently this is based on Oracle 12c. The test environment is in Windows 10.
Views: 889 Sam Dhanasekaran
Oracle Cloud - User Creation
 
09:52
How to Create Users and Grant Roles in Oracle Cloud
Views: 186 Rahul Phatak
How to create a new user in SQL command line,Granting privileges & Revoking privileges from the user
 
14:31
Title: How to create a new user in SQL command line,Assigning Privileges(Granting)(Select,Insert,Update,Delete) to the user and Removing privileges(Revoke) from the user. Created by: Hardik M.Parmar, Lecturer,Computer Engg.Dept., J.H.Desai Polytech,Palsana
Views: 25822 Hardik Parmar
Oracle Data Export and Import using DataPump expdp and impdp
 
09:38
Oracle Data Export and Import using DataPump expdp and impdp
Views: 173947 Abbasi Asif
SQL tutorial 38: How to create user using SQL Developer in Oracle database
 
06:52
How to create new user accounts using SQL Developer in oracle database. In This tutorial you will learn how to create a new user account. How to setup a database connection with SyS user. How to grant privileges to the user ----_Links_--- Blog :http://bit.ly/create_user_account Video Tut 4: http://youtu.be/wSqoXRlXDUU How to create database: http://youtu.be/enFFezPYhCg Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=kb4rc1 Amazon Wishlist: http://bit.ly/wishlist-amazon Contacts E-Mail [email protected] Twitter https://twitter.com/rebellionrider Instagram http://instagram.com/rebellionrider Facebook. https://www.facebook.com/imthebhardwaj Linkedin. http://in.linkedin.com/in/mannbhardwaj/ Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com
Views: 61255 Manish Sharma
How to fix "insufficient privileges to access this directory" error
 
02:23
Problem: While installing a program, the user receives the following error message: "The installer has insufficient privileges to access this directory". Solution: 1. manually create the required folder, 2. download the compressed registry file : ► https://drive.google.com/open?id=0Bw-8fzdMfWSFREZUTzZqNFROWkk 3. extract the contents to a folder you like, 4. double-click the "Take Ownership.reg" file to add it to the Windows Registry, 5. go to the folder that you manually created, right-click on it, click "Take ownership" 6. try to continue the setup, click Retry.
Views: 145959 furulevi
Creating a User and Privileges using Enterprise Manager Express
 
02:04
Oracle University instructor Darryl Balaski discusses creating users and privileges using Enterprise Manager Express.
Installing PHP and the Oracle Instant Client with Xampp
 
09:40
How To Connect Oracle with PHP code through XAMPP ....... 1. Download Oracle Instant Client from oracle site 2.Download Oracle Instant Client according system specification like X86 or 64 bit' 3.Accept oracle agreement 4. before download oracle ask to you oracle id to download so signup with oracle and enjoys 5. download following pacakages from oracle A) instantclient-basic-nt-12.2.0.1.0.zip b) instantclient-sdk-nt-12.2.0.1.0.zip 6. download above both packages. 7. and extract both packages in C:\php-sdk\oracle\x86\instantclient_12_1 location 8. this location differ according to xampp installation directory. -- To know extract loaction start apache server and browse http://localhost/dashboard/phpinfo.php --c:\php-sdk\oracle\x86\instantclient_12_1\ (it is the location) 9.extract packages at above locations 10. go to xampp control panel and open apache php.ini 11. search oci in php.ini 12. after searching you will found ;extension=php_oci8_12c.dll line in php.ini remove semicolon from that line and save the file. 13. write your oracle connection you are success fully connected with oracle the connection string are here 14.if some problem exists restart apache and enjoy //Create connection to Oracle $conn = oci_connect("andy", "andy", "//10.68.102.2:1521/ahis"); if (!$conn) { $m = oci_error(); echo $m['message'], "\n"; exit; } /*else { print "Connected to Oracle!"; } */ // Close the Oracle connection oci_close($conn); Thanks
Views: 1383 ithelpsonly
Developing Value from Oracle Audit Vault
 
48:15
Oracle’s Audit Vault product is increasing in popularity having been voted Database Trends and Reader’s Choice Best Database Security Solution for 2014. Oracle Audit Vault provides a comprehensive and flexible monitoring solution by consolidating audit data from Oracle and non-Oracle databases, operating systems, directory, file systems, and application log data. The Oracle Audit Vault delivers over one hundred (100) reports, including compliance reports, as well as provides the ability to easily modify and create new reports using BI Publisher. For auditors and IT security professionals, the Oracle Audit Vault presents significant new opportunities for Oracle database activity monitoring and security. This educational webinar is targeted for auditors and IT security professionals and reviews the Oracle Audit vault and how Integrigy’s log and audit Framework can be easily implemented using the Oracle Audit Vault.
Views: 2208 Integrigy
Error in writing to directory temp oracle universal installer needs you to have permission
 
01:45
error in writing to directory temp oracle universal installer needs you to have permission in this area to install. installation cannot continue . please make sure temp is set to a valid writable directory.
grant or revoke delegated admin privilege
 
00:23
Made with Monosnap - http://monosnap.com
OAuth Additional Grant Types
 
03:31
Learn how the Refresh Token and Assertion flows are implemented in OAuth. This videos forms part of the Oracle Cloud Primer Series. For more details visit the Cloud Primer Playlist at: http://bit.ly/cloud_primers ================================= To improve the video quality, click the gear icon and set the Quality to 1080p/720p HD. For more information, see http://www.oracle.com/goto/oll Copyright © 2017 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
Query Parameter in Oracle Datapump
 
19:05
Hello Friends Today, In this video I used to show you How to Used Data pump Query Parameter. In Query Parameter we can take export backup using particular query. Suppose iwant to take a export backup of EMP table but in this table i want to take backup only department no 20. so it is possible . please watch this video and subscribe In Some Methods i am showing you. Method 1: (Using Parameter File) ------------------------------------------------------------ 1. Create Table Test. (Create table scott.test as select * from scott.emp;) 2. Create Par file. ------------------------------------------------------------ directory=dump dumpfile=d1.dmp tables='SCOTT . TEST' query=TEST:"WHERE deptno=20" ---------------------------------------------------------------- Save this file test.par --------------------------------------------------------------- 3. Go to Command Prompt Export expdp system/admin parfile='/u01/app/parag/test.par’  Import impdp system/admin directory=dump dumpfile=d1.dmp tables=‘SCOTT . TEST‘ ------------------------------------------------------------------------------------- Method 2: ------------------------------------------------------------ 1. Create Table Test. (Create table scott.test as select * from scott.emp;) 2. Go to Command Prompt Export expdp system/admin directory=dump dumpfile=d2.dmp tables=‘SCOTT . TEST ’ query=TEST:\”WHERE deptno=20\”  Import impdp system/admin directory=dump dumpfile=d2.dmp tables=‘SCOTT . TEST ' -----------------------------------------------------------------------------------------------------------
Views: 388 Parag Mahalle
Creation of Users, Groups in Oracle Hyperion Planning
 
09:51
User directories, Native Directory and corporate user directories--are the source for users. The authentication and the authorization processes utilize user information. Groups are containers for users or other groups. You can create and manage Native Directory groups from Shared Services Console. You can provision the groups to grant permissions for EPM System products registered with Shared Services.
TUTORIAL - Administering User Security & Schema Object Oracle 11g Enterprise Edition
 
05:06
It's my colleges mid semester homework Part 1 Music : The Chainsmoker - All We Know twenty one pilots - Heathens
Views: 102 Sloogy Panda
Oracle DB Vs MySQL for Enterprise DataBase Deployments
 
08:54
Oracle DB is big, and expensive, but it brings a lot to the "table" when compared with MySQL. MySQL has limited ability to audit. MySQL's security is unsophisticated. There are no groups or roles, no ability to deny a privilege (you can only grant privileges). A user who logs in with the same username and password from different network addresses may be treated as a completely separate user. There is no built-in encryption comparable to Oracle. MySQL's Authentication is built-in. There is no LDAP, Active Directory, or other external authentication capability. MySQL has no MPP (massively parallel processing ) support. Unlike Oracle MySQL has no fractional-second storage type for times, dates, or intervals. There is no RAC (Real Application Cluster) support in My SQL, and no failover or server promotion either. These are strong features in Oracle MySQL's number of joins per query is limited to 61. Oracle's limit is much larger. MySQL Replication is asynchronous and has many limitations and edge cases. For example, it is single-threaded, so a powerful slave can find it hard to replicate fast enough to keep up with a less powerful master.
Views: 20183 Biz of Tech
Database 12c Creating users & roles
 
07:54
Oracle DB 12c Creating users & roles
Views: 655 Ora Tube
Integrating Oracle Secure Global Desktop with Microsoft Active Directory
 
03:15
This Video demonstrate's Oracle Secure Global Desktop with Microsoft Active Directory Integration
Views: 943 Prashant Rangi
Modulo I  Introduccion a admin  Oracle 12c
 
12:20
Nombre: NOEL EVELIO MENA AMAYA. Carnet: 25-0025-2011. EXAMEN 1: Introduccion a la admin. Oracle 12c. 1--Cree una base de datos nueva sin listener y coloque de nombre a la instancia [ORCLCarnet], donde su Carnet es su número de carnet sin guiones. Por ejemplo: [ORCL2120232010]. También es requerido que se cree el esquema de ejemplo de la base de datos durante el proceso de instalación. ---creamos la base de datos y le asignamos el listener. dbca - para crear la base de datos Clave: Pa$$w0rd 2-- Cree un listener para la base de datos creada. netca - para crear listener. ---- Primero crearmos el listener. 3-- Inicie sesión como sysdba y cree un usuario AlumnoCarnet, donde Carnet es su número de carnet sin guiones. Por ejemplo Alumno212023205510. create user Alumno2500252011 identified by Pa$$w0rd; 4--Con el esquema de ejemplo, se crea automáticamente el usuario hr desactivado. Debe de activarlo y colocarle una contraseña alter user hr account unlock; alter user hr identified by Pa$$w0rd; 5--crear un tablespace llamado examen que tenga 200mb de espacio create tablespace Examen datafile '/home/oracle/examents.dbf' SIZE 20M; 6--- asigne por defecto el tablespace al usuario alter user Alumno2500252011 default tablespace Examen; 7--Asigne permisos de administrador al usuario AlumnoCarnet con la opción para que pueda brindar permisos a otros usuarios. GRANT ALL PRIVILEGES TO Alumno2500252011 WITH ADMIN OPTION; 8--Inicie sesión con el usuario AlumnoCarnet y cree un nuevo tablespace llamado ExamenAlumno. sqlplus Alumno2500252011/[email protected] create tablespace ExamenAlumno datafile '/home/oracle/ExamenAlumno.dbf' SIZE 10M; 9--Cree un nuevo rol con permisos de administración que se llame Gestores. create role Gestores; grant all privileges to gestores with admin option; 10--Inicie sesión como sysdba y retire los permisos de administración al usuario AlumnoCarnet. sqlplus / as sysdba revoke all privileges from Alumno2500252011; 11--Asigne el rol Gestores al usuario AlumnoCarnet grant Gestores to Alumno2500252011; 12--Realice un backup de la base de datos exportando a un archivo con nombre Bkup2018 -------CREAR UN DIRECTORIO VIRTUAL PARA GUARDAR EL RESPALDO---------------------------- create or replace directory BackupExamen as '/home/ORCL2500252011'; -------- DARLE PERMISOS AL USUARIO----------------------- grant read, write on directory BackupExamen to system; -------------------------EXPORTAR TODA LA BASE ------------------------ Exit expdp system/[email protected] full=y directory=BackupExamen dumpfile=Bkup2018.dmp logfile=fulldump.log --- inicia la creacion del backup.... 13---Cree un nuevo tablespace llamado ExamenPostBackup con 100MB de espacio create tablespace ExamenPostBackup datafile '/home/oracle/ORCL2500252011/examentpostbackup1.dbf' size 10m; 14-- Realice una recuperación del respaldo ejecutado en el punto 13 y compruebe que el tablespace ExamenPostBackup no está incluido en la base de datos ya que fue realizado después de hacer el respaldo. ----------------IMPORTAR UNA BASE DE DATOS--------------- impdp system/[email protected] full=y directory=BackupExamen dumpfile=full.dmp logfile=importfull.log select * from v$database; select * from v$tablespace;
Views: 6 Noel Mena
Absence Request in Oracle SSHR
 
29:33
For more videos on payroll, visit our website at http://www.erpwebtutor.com
Views: 6921 ERPWebTutor
SQL and PLSQL INTERVIEW 7- HOW TO CREATE ORACLE SCHEMA USER AND CHANGE PASSWORD OF USER
 
04:09
If You have Any Queries Comment Me in Comment Box or MY WHATSUP NUMBER 08508598428. Subscribe this Youtube Channel for Upcomming Videos. join My facebook Sql and PLSQL Discussion Page https://www.facebook.com/Oracle-SQL-PLSQL-Practical-Discussion-334342290310499/
Views: 197 Manikandan R
USER MANAGEMENT HOW TO CREATE  GRANT REVOKE PROXY USER
 
07:43
USER MANAGEMENT-HOW TO CREATE PROXY USER GRANT/REVOKE PROXY =========================================================== proxy user is a user that is allowed to "connect on behalf of another user" create user proxy1 identified by proxy1; create user proxy2 identified by proxy2; grant connect to proxy1,proxy2;(only create session privilege) alter user naveen grant connect through proxy1, proxy2; alter user proxy1 grant connect through proxy2; alter user naveen revoke connect through proxy1,proxy2; alter user proxy1 revoke connect through proxy2; conn proxy1[naveen]/proxy1 conn proxy2[naveen]/proxy2 conn proxy2[proxy1]/proxy2 set lines 180 pages 200 col a20 for proxy select * from proxy_users; (proxy_users -- data dictionary view) select sys_context('USERENV','PROXY_USER') from dual;
Views: 269 Praveen Biyyapu

Term papers writing service
Free printable cover letter samples
Broadcast meteorology cover letter
Sending cover letter by email
Student receptionist cover letter