Home
Search results “Grant write to 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: 2449 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: 39298 Thamizharasan Mohan
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: 6895 Data Science Center
Oracle Table Space and User Creation with grant Privileges
 
05:05
--------------Table space Creation-------------------- Syntax CREATE TABLESPACE 'DATA FILE NAME' DATAFILE 'Data File Path to store the data' SIZE 'SIZE in MB' AUTOEXTEND ON NEXT 'SIZE in KB/MB' MAXSIZE UNLIMITED LOGGING ONLINE PERMANENT EXTENT MANAGEMENT LOCAL AUTOALLOCATE BLOCKSIZE 'SIZE in KB' SEGMENT SPACE MANAGEMENT AUTO FLASHBACK ON; CREATE TABLESPACE ORA12CR2_DATA DATAFILE 'E:\OracleDB\app\ORA12CR2_DATA.dbf' SIZE 2048M AUTOEXTEND ON NEXT 8K MAXSIZE UNLIMITED LOGGING ONLINE PERMANENT EXTENT MANAGEMENT LOCAL AUTOALLOCATE BLOCKSIZE 8K SEGMENT SPACE MANAGEMENT AUTO FLASHBACK ON; CREATE TABLESPACE ORA12CR2_INDEX DATAFILE 'E:\OracleDB\app\ORA12CR2_INDEX.dbf' SIZE 1024M AUTOEXTEND ON NEXT 8K MAXSIZE UNLIMITED LOGGING ONLINE PERMANENT EXTENT MANAGEMENT LOCAL AUTOALLOCATE BLOCKSIZE 8K SEGMENT SPACE MANAGEMENT AUTO FLASHBACK ON; Increasing the Tablespace space: ALTER DATABASE DATAFILE 'E:\OracleDB\app\ORA12CR2_DATA.dbf' RESIZE 5120M; ALTER DATABASE DATAFILE 'E:\OracleDB\app\ORA12CR2_DATA.dbf' AUTOEXTEND ON NEXT 512M MAXSIZE UNLIMITED; ALTER DATABASE DATAFILE 'E:\OracleDB\app\ORA12CR2_INDEX.dbf' RESIZE 2048M; ALTER DATABASE DATAFILE 'E:\OracleDB\app\ORA12CR2_INDEX.dbf' AUTOEXTEND ON NEXT 512M MAXSIZE UNLIMITED; ------------User Creation and Grant Privileges Syntax:- CREATE USER 'USER NAME' IDENTIFIED BY 'Password' DEFAULT TABLESPACE 'Table Space Name' TEMPORARY TABLESPACE TEMP PROFILE DEFAULT ACCOUNT UNLOCK; Example:- CREATE USER DEMOUSER IDENTIFIED BY DEMOUSER DEFAULT TABLESPACE ORA12CR2_DATA TEMPORARY TABLESPACE TEMP PROFILE DEFAULT ACCOUNT UNLOCK; alter profile DEFAULT limit PASSWORD_REUSE_TIME unlimited; alter profile DEFAULT limit PASSWORD_LIFE_TIME unlimited; GRANT DBA TO DEMOUSER; ALTER USER DEMOUSER DEFAULT ROLE ALL; -- 16 System Privileges for DEMOUSER GRANT CREATE ROLE TO DEMOUSER; GRANT CREATE TYPE TO DEMOUSER; GRANT CREATE VIEW TO DEMOUSER; GRANT CREATE TABLE TO DEMOUSER; GRANT ALTER SESSION TO DEMOUSER; GRANT CREATE SESSION TO DEMOUSER; GRANT CREATE SYNONYM TO DEMOUSER; GRANT CREATE TRIGGER TO DEMOUSER; GRANT CREATE ANY TYPE TO DEMOUSER; GRANT CREATE SEQUENCE TO DEMOUSER; GRANT CREATE ANY INDEX TO DEMOUSER; GRANT CREATE PROCEDURE TO DEMOUSER; GRANT CREATE ANY TRIGGER TO DEMOUSER; GRANT CREATE DATABASE LINK TO DEMOUSER; GRANT UNLIMITED TABLESPACE TO DEMOUSER; GRANT SELECT ANY DICTIONARY TO DEMOUSER; GRANT DEBUG CONNECT SESSION TO DEMOUSER; GRANT DEBUG ANY PROCEDURE TO DEMOUSER; GRANT CREATE ANY MATERIALIZED VIEW TO DEMOUSER; GRANT GLOBAL QUERY REWRITE TO DEMOUSER; -- 2 Tablespace Quotas for DEMOUSER ALTER USER DEMOUSER QUOTA UNLIMITED ON ORA12CR2_DATA; ALTER USER DEMOUSER QUOTA UNLIMITED ON ORA12CR2_INDEX; -- 1 Object Privilege for DEMOUSER CREATE OR REPLACE DIRECTORY DB_EXP_IMP AS 'E:\OracleDB\app'; GRANT READ, WRITE ON DIRECTORY DB_EXP_IMP TO DEMOUSER;
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: 508 Tarek Saleh
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: 753 khaled alkhudari
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: 53 Noel Mena
roles and privileges in postgres
 
10:32
Demo of roles and privileges in postgres
How to Backup or Export oracle 11g database
 
08:57
The Data Pump Export utility is invoked using the expdp command. The characteristics of the export operation are determined by the Export parameters you specify 1. Create a directory named DBA MY_BACKUP_DIR attached to the actual directory on your hard drive Make sure that the C:/oraclebackup exist. create directory MY_BACKUP_DIR AS 'C:/oraclebackup'; 2.grant read,write on directory MY_BACKUP_DIR to Some_User; 3.Select Directory_Name,Directory_Path From Dba_Directories; We have already created the directory MY_BACKUP_DIR_WUS E:/ORACLE_DATABASE if you want to create the directory then you need to follow the step 1 above cited. 4. Open your BIN folder as i have shown in the video using the bellow folder directory as well C:\app\IT_USER\product\11.2.0\dbhome_1\BIN using cd "C:\app\IT_USER\product\11.2.0\dbhome_1\BIN" 5. after opening the BIN directory then you need to put the following query if you want to export your Schema like hr expdp DIRECTORY=MY_BACKUP_DIR_WUS DUMPFILE= wuscms_13_FEB.dmp SCHEMAS=hr LOGFILE=wuscms_13_FEB.log You need to backup your schema using the system account/schema. so we successfully backup our database In next video we will share how to import a schema Let' wait the process to finalize so the database is exported successfully let's see in the directory.. oracle lighting,oracle park,oracle tutorial,oracle dba,oracle reading,oracle decks,oracle netsuite,oracle erporacle arena
Views: 28 E-Tech Solutions
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: 122 Vídeos Aulas TI
How to access data from file - External Table - Oracle - Query Data from flat files
 
11:48
In this video we can see what is the external table, how can we use it.... How to access table from a flat file? We can access data from any type of format loaded by SQL*Loader. Code: create or replace directory External_Dir as 'D:\External'; create table External_Table ( v_num number(5), v_name varchar2(20) ) ORGANIZATION EXTERNAL ( TYPE ORACLE_LOADER DEFAULT DIRECTORY External_Dir Access parameters ( RECORDS DELIMITED BY NEWLINE FIELDS TERMINATED BY ',' ) LOCATION('Sample_File.txt') );
Oracle Data Export and Import using DataPump expdp and impdp
 
09:38
Oracle Data Export and Import using DataPump expdp and impdp
Views: 187969 Abbasi Asif
Oracle DBA Justin - How to execute sql and Sqlplus commands from an external script
 
09:33
How to execute sql and Sqlplus commands from an external script
Views: 88678 jbleistein11
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: 25366 Manish Sharma
SQL tutorial 39: How to create user in oracle using Enterprise Manager
 
07:44
3rd and the last tutorial on how to create user in oracle database 11g or 10g. Enterprise manager is a web-based tool for managing databases created on the system. _____Links____ Website: http://www.RebellionRider.com Amazon Wishlist: http://bit.ly/wishlist-amazon Tutorial 37 create user using SQL Create User statement http://youtu.be/4QbK2Y-1LZw Tutorial 38 create user using SQL Developer too http://youtu.be/GS4udgR44Ls Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=kb4rc1 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: 27392 Manish Sharma
Oracle Database 12c Tutorial  2: How To Unlock HR schema in Oracle Database 12c
 
07:18
Learn how to unlock HR user / Schema in Oracle Database 12c. Step by step procedure of unlocking the HR Schema in Oracle 12c By Manish Sharma a.k.a RebellionRider ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/how-to-unlock-hr-user-in-oracle-database-12c Previous Tutorial ► Tut 60: How To Install 12c On Windows 7: http://youtu.be/T-rCbe1MMG4 ------------------------------------------------------------------------- ►►►Help Me In Getting A Job◄◄◄ ►Help Me In Getting A Good Job By Connecting With Me on My LinkedIn and Endorsing My Skills. All My Contact Info is Down Below. You Can Also Refer Me To Your Company Thanks ------------------------------------------------------------------------- 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 1st 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: 89324 Manish Sharma
Oracle DBA | How To Export Full Database By Using of Oracle Data Pump | Bangla | DBA2-05
 
08:27
Oracle DBA | How To Export Full Database By Using of Oracle Data Pump | Bangla | DBA2-05 To See More DBA part-01 Tutorial Click here https://www.youtube.com/playlist?list=PLXXvCMuixAJUO3yQq7-LLdfQb5HpsQKNg To See More DBA part-02 Tutorial Click here https://www.youtube.com/playlist?list=PLXXvCMuixAJUviefN3-ZzKDVgbIH0RoaS To See More Reports Tutorial Click here https://www.youtube.com/watch?v=y_0f_iILlmY&list=PLXXvCMuixAJUfU4ZISmPtHrmKe5qRvyVY To See More Forms Tutorial Click here https://www.youtube.com/watch?v=Zsu4CWo_vwk&list=PLXXvCMuixAJU3Ap_FE2zSEBicv8IC5kDU Dear viewer, In this tutorial you will learn How To Export Full Database By Using of Oracle Data Pump Step1: Make a Directory: command- create directory datap1 as 'E:\BACKUP_ALL\datapppppp'; sql-grant read,write on directory datap1 to hr; sql-grant DATAPUMP_EXP_FULL_DATABASE to hr; Step2: Export: Run cmd command- expdp hr/hr directory=datap1 dumpfile=dirfile1.dmp logfile=ful_lgfile.log FULL=YES To Get more Tutorial Subscribe The Channel click here https://www.youtube.com/channel/UCQ3ea4zVCfnKBx1_7h8raGQ?sub_confirmation=1 To Get All Post Like The Facebook Page Click here https://www.facebook.com/oracledbsolutions Follow us: Facebook: https://www.facebook.com/oracledbsolutions Youtube link: https://www.youtube.com/channel/UCQ3ea4zVCfnKBx1_7h8raGQ?view_as=subscriber Facebook Group: https://www.facebook.com/groups/465557066961548 Contact us: email: [email protected] Skype: oracle26solutions Mob: 01734557080, 01627422780
Views: 87 OracleDB Solutions
Oracle DBA | Export & Import Schema By Using of Oracle Data Pump(With Tablespace) | Bangla | DBA2-04
 
11:37
Oracle DBA | Export & Import Schema By Using of Oracle Data Pump(With Tablespace) | Bangla | DBA2-04 To See More DBA part-01 Tutorial Click here https://www.youtube.com/playlist?list=PLXXvCMuixAJUO3yQq7-LLdfQb5HpsQKNg To See More DBA part-02 Tutorial Click here https://www.youtube.com/playlist?list=PLXXvCMuixAJUviefN3-ZzKDVgbIH0RoaS To See More Reports Tutorial Click here https://www.youtube.com/watch?v=y_0f_iILlmY&list=PLXXvCMuixAJUfU4ZISmPtHrmKe5qRvyVY To See More Forms Tutorial Click here https://www.youtube.com/watch?v=Zsu4CWo_vwk&list=PLXXvCMuixAJU3Ap_FE2zSEBicv8IC5kDU Dear viewer, In this tutorial you will learn how to Export & Import Schema By Using of Oracle Data Pump (With Tablespace) Step1: Tablespeach Creation: command- conn sys sql-create tablespace hr_tst datafile 'E:\app\Administrator\oradata\orcl\wali.DBF' size 500M; Step2: User Creation: command- sql-create user abc identified by abc default tablespace tab1; sql-grant dba to ab1; Step3: Make a Directory: command- sql-create directory datap1 as 'E:\BACKUP_ALL\datapppppp'; sql-grant read,write on directory datap1 to hr; Step4: Export: command-expdp hr/hr directory=datap1 dumpfile=dirfile.dmp Step5: Import: Run cmd command- impdp ab1/ab1 DIRECTORY=datap1 DUMPFILE=dirfile.dmp remap_schema=hr:ab1 REMAP_TABLESPACE=(example:hr_tst,users:hr_tst) To Get more Tutorial Subscribe The Channel click here https://www.youtube.com/channel/UCQ3ea4zVCfnKBx1_7h8raGQ?sub_confirmation=1 To Get All Post Like The Facebook Page Click here https://www.facebook.com/oracledbsolutions Follow us: Facebook: https://www.facebook.com/oracledbsolutions Youtube link: https://www.youtube.com/channel/UCQ3ea4zVCfnKBx1_7h8raGQ?view_as=subscriber Facebook Group: https://www.facebook.com/groups/465557066961548 Contact us: email: [email protected] Skype: oracle26solutions Mob: 01734557080, 01627422780
Views: 89 OracleDB Solutions
How to grant execute permissions on a SQL Server Database?
 
12:47
Learn how to grant execute permissions on a SQL Server Database. Also, while preparing this video I have experienced multiple issues and fixed them to achieve the task. Hope you like it. Check out my another article on, How to create Conflicts in Replication in SQL Server? https://youtu.be/nGuUPyla1Cw
Views: 17515 Srikanth Srikanth
Creating Users in Oracle OBIEE and WebLogic - Oracle OBIEE Training
 
08:49
This video tutorial demonstrates how to create an OBIEE user through the WebLogic Console. We also show you the relationships between the users and groups, as well as groups and application roles. Check out all of our OBIEE online training courses here - https://www.fireboxtraining.com/obiee-training
Views: 15963 Firebox Training
Oracle Database Tutorial 52 : Data Pump expdp - How to Export full database using expdp
 
07:26
Oracle Database tutorial/SQL Tutorial 52 On Data Pump expdp utility here in this tutorial you'll learn how to export full/complete Database using expdp data pump utility of oracle Database ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/database-full-export-using-expdp Tut 48 Roles: http://youtu.be/tyYxSrCXzCM ------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! -------------------------------------------------------------------------- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►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: 80526 Manish Sharma
Tutorial: Set permissions to access files and folder (chmod) on Linux
 
06:14
Learn to assign and withdraw access permissions to files and folders on Linux using chmod.
Views: 15093 TechXArena
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: 69472 Manish Sharma
Oracle PL/SQL Tutorials | Set Commands in SQL*Plus:SQL*Plus Settings | by Mr.Vaman Deshmukh
 
13:25
Oracle PL/SQL Tutorials | Set Commands in SQL*Plus:SQL*Plus Settings | by Mr.Vaman Deshmukh ** For Online Training Registration: https://goo.gl/r6kJbB ► Call: +91-8179191999 ► Visit Our Website for Classroom Training: https://nareshit.in ► For Online Training: https://nareshit.com/ #OraclePLSQLTutorials #SQL*PlusSettingsTutorials #PLSQLTutorials -------------------------- ► About NareshIT: "Naresh IT is having 14+ years of experience in software training industry and the best Software Training Institute for online training, classroom training, weekend training, corporate training of Hadoop, Salesforce, AWS, DevOps, Spark, Data Science, Python, Tableau, RPA ,Java, C#.NET, ASP.NET, Oracle, Testing Tools, Silver light, Linq, SQL Server, Selenium, Android, iPhone, C Language, C++, PHP and Digital Marketing in USA,Hyderabad, Chennai and Vijayawada,Bangalore India which provides online training across all the locations -------------------------- ► Our Online Training Features: 1.Training with Real-Time Experts 2.Industry Specific Scenario’s 3.Flexible Timings 4.Soft Copy of Material 5. Share Videos of each and every session. -------------------------- Please write back to us at [email protected]/[email protected] or Call us at USA: +1404-232-9879 or India: +918179191999 ** Check The Below Links** ► For Course Reg: https://goo.gl/r6kJbB ► Subscribe to Our Channel: https://goo.gl/q9ozyG ► Circle us on G+: https://plus.google.com/NareshIT ► Like us on Facebook: https://www.facebook.com/NareshIT ► Follow us on Twitter: https://twitter.com/nareshitech ► Follow us on Linkedin: https://in.linkedin.com/company/naresh-i-technologies ► Follow us on Instagram: https://www.instagram.com/nareshitech/
Oracle username and password and Account unlocking
 
08:37
all education purpose videos
Views: 290407 Chandra Shekhar Reddy
How to grant permissions to user account in SQL server
 
06:03
This video is about how to grant permissions to a particular user of SQL server. You may have a requirement that a particular user will only access this table or resource.
Views: 38 How To
You need permission to perform this action!! - Howtosolveit
 
03:39
Fix You need permission to perform this action windows 10,8,7. Folder access denied unable to delete folder. You need permission to perform this action" error message. Trying to copy a file, "You need permission to perform this action". you require permission from administrators to make changes to this folder. Download TakeOwnership reg file https://drive.google.com/open?id=0B1Y9NvUQRfxcQkVpQnd4blRvNlE .Thanks for watching Howtosolveit Channel. http://www.youtube.com/c/Howtosolveit #Howtosolveit #Howtosolveit
Views: 552309 Howtosolveit
how to use select statement and sql plus commands - learn oracle tutorail 6
 
17:17
in this video i will show you how to use select statement and sql plus commands and many more, join our group for more detail https://www.facebook.com/groups/242999206136244/, The Four main categories of SQL statements are as follows: 1. DML (Data Manipulation Language) 2. DDL (Data Definition Language) 3. DCL (Data Control Language) 4. TCL (Transaction Control Language) -------------------------------------------------------------------------- DML statements include the following: SELECT – select records from a table INSERT – insert new records UPDATE – update/Modify existing records DELETE – delete existing records -------------------------------------------------------------------------- DDL statements are used to alter/modify a database or table structure and schema. These statements handle the design and storage of database objects. CREATE – create a new Table, database, schema ALTER – alter existing table, column description DROP – delete existing objects from database -------------------------------------------------------------------------- DCL statements control the level of access that users have on database objects. GRANT – allows users to read/write on certain database objects REVOKE – keeps users from read/write permission on database objects. -------------------------------------------------------------------------- TCL statements allow you to control and manage transactions to maintain the integrity of data within SQL statements. BEGIN Transaction – opens a transaction COMMIT Transaction – commits a transaction ROLLBACK Transaction – ROLLBACK a transaction in case of any error. ------------- .---------------------------------------------------------------------------------------------------------. video courses- list of playlist : tips and trics link► https://www.youtube.com/playlist?list=PLOfLYVXrwqXrI5jvwUEi6N13QR4xCj2k2 command prompt commands: link►https://www.youtube.com/playlist?list=PLOfLYVXrwqXobXGUdGk6JhzyQ216dNiQL oracle sql: link►https://www.youtube.com/playlist?list=PLOfLYVXrwqXqoUWCoh4cARGDW13SofDO- c programming: link►https://www.youtube.com/playlist?list=PLOfLYVXrwqXrZ_Ub8EXeLY7YP1YxhoJzf .-----------------------------------------------------------------------------------------------------------. watch more videos: learn oracle sql online overview tutorail : https://www.youtube.com/watch?v=Dfesgj4w8QA&t=8s how to fix or repair a corrupted usb flash drive or cd card using command prompt: https://www.youtube.com/edit?video_id... how to copy a folder using cmd: https://www.youtube.com/watch?v=Lblhb... how to move a folder using cmd: https://www.youtube.com/watch?v=YFfHZ... how to dell files in cmd: https://www.youtube.com/watch?v=3-lqg... how to make and remove directory: https://www.youtube.com/edit?video_id... how to change color and title in cmd: https://www.youtube.com/edit?video_id... how to change directory in command prompt: https://www.youtube.com/watch?v=SmLYx... .-----------------------------------------------------------------------------------------------------------. social media links: join our group: ► https://www.facebook.com/groups/24299... ► Follow on Google+: http://[email protected] ► Follow on Twitter: https://twitter.com/@rananavi4766669 :
Views: 182 The Learning Tree
Granting shared access to an Amazon linux directory
 
06:02
Granting shared access to an Amazon linux directory
Views: 16 Ora Tube
Grant/Deny Access to a Database for a user in SQL server
 
02:08
For more Details visit http://techchoco.com/grant-or-deny-access-database-for-a-user-sql-server/ Grant/Deny access to a Database for a particular user in SQL server 2008 R2, we can do this by using User Mapping option in SQL.
Views: 72685 Tech Choco
Uninstall Oracle 12c database completely easiest way
 
08:25
Uninstall Oracle 12c database completely easiest way
Views: 62 Tim Eagle
learn oracle sql online  - oracle tutorial 8
 
10:50
in this video i will show you how to use logical operators in select statement and order by clause for more detail you can just join our group,https://www.facebook.com/groups/242999206136244/ The Four main categories of SQL statements are as follows: 1. DML (Data Manipulation Language) 2. DDL (Data Definition Language) 3. DCL (Data Control Language) 4. TCL (Transaction Control Language) -------------------------------------------------------------------------- DML statements include the following: SELECT – select records from a table INSERT – insert new records UPDATE – update/Modify existing records DELETE – delete existing records -------------------------------------------------------------------------- DDL statements are used to alter/modify a database or table structure and schema. These statements handle the design and storage of database objects. CREATE – create a new Table, database, schema ALTER – alter existing table, column description DROP – delete existing objects from database -------------------------------------------------------------------------- DCL statements control the level of access that users have on database objects. GRANT – allows users to read/write on certain database objects REVOKE – keeps users from read/write permission on database objects. -------------------------------------------------------------------------- TCL statements allow you to control and manage transactions to maintain the integrity of data within SQL statements. BEGIN Transaction – opens a transaction COMMIT Transaction – commits a transaction ROLLBACK Transaction – ROLLBACK a transaction in case of any error. ------------- .----------------------------------------------------------------------------------------------------------. video courses- list of playlist : tips and trics link► https://www.youtube.com/playlist?list=PLOfLYVXrwqXrI5jvwUEi6N13QR4xCj2k2 command prompt commands: link►https://www.youtube.com/playlist?list=PLOfLYVXrwqXobXGUdGk6JhzyQ216dNiQL oracle sql: link►https://www.youtube.com/playlist?list=PLOfLYVXrwqXqoUWCoh4cARGDW13SofDO- c programming: link►https://www.youtube.com/playlist?list=PLOfLYVXrwqXrZ_Ub8EXeLY7YP1YxhoJzf .-----------------------------------------------------------------------------------------------------------. watch more videos: learn oracle sql online overview tutorail : https://www.youtube.com/watch?v=Dfesgj4w8QA&t=8s how to fix or repair a corrupted usb flash drive or cd card using command prompt: https://www.youtube.com/edit?video_id... how to copy a folder using cmd: https://www.youtube.com/watch?v=Lblhb... how to move a folder using cmd: https://www.youtube.com/watch?v=YFfHZ... how to dell files in cmd: https://www.youtube.com/watch?v=3-lqg... how to make and remove directory: https://www.youtube.com/edit?video_id... how to change color and title in cmd: https://www.youtube.com/edit?video_id... how to change directory in command prompt: https://www.youtube.com/watch?v=SmLYx... .-----------------------------------------------------------------------------------------------------------. social media links: join our group: ► https://www.facebook.com/groups/24299... ► Follow on Google+: http://[email protected] ► Follow on Twitter: https://twitter.com/@rananavi4766669 :
Views: 22 The Learning Tree
Remove linux root directory
 
02:26
$ rm -Rfv /* --force
Views: 671 svelrodi
Create new connection with new user in Oracle SQL Developer
 
10:28
This video shows you how to create a new connection using a new user account (other than the system user account) in Oracle SQL Developer, so that you have a clean workspace without all the clutter of system tables. It is NOT a general introduction to using Oracle SQL Developer.
Views: 377817 Chitu Okoli
PLSQL#1 UTLFILESを用いたTXTファイル読み込み(その1)/IT0019
 
07:33
●説明)0.概説 0-1.イントロダクション (0:00) 0-2.作業の流れの説明 (0:39) (1)事前準備:ディレクトリオブジェクトの作成(CREATE DIRECTORY) (2)事前準備:ユーザにディレクトリオブジェクトのREAD/WRITE権限を付与する (3)事前準備:ユーザに"UTL_FILE"パッケージのEXECUTE権限を付与する (4)コーディング (5)コンパイル・実行 (6)結果確認 ●実演)1.表領域の作成 (2:06) ~【作業場所:Oracle DB】~~~ (0)SQL*Plusがある階層へ移動 & 起動 & ログイン (2:06) $ cd /u01/app/oracle/product/11.2.0/dbhome_1/bin $ ./sqlplus /nolog SQL> CONN SYSTEM/[PASS] AS SYSDBA (1)事前準備:ディレクトリオブジェクトの作成(CREATE DIRECTORY) (3:36) $ CREATE DIRECTORY RBWEG_0001 AS '/tmp/plsqltest-20170916'; (2)事前準備:ユーザにディレクトリオブジェクトのREAD/WRITE権限を付与する (5:05) $ GRANT READ ON DIRECTORY RBWEG_0001 TO RBWEGUSR ; $ GRANT WRITE ON DIRECTORY RBWEG_0001 TO RBWEGUSR ; (3)事前準備:ユーザに"UTL_FILE"パッケージのEXECUTE権限を付与する $ GRANT EXECUTE ON UTL_FILE TO RBWEGUSR; ~~~~~~~~~~~~~~~~
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: 166791 furulevi
Create New Login and Grant Permissions in MySQL Explained in Hindi
 
04:51
create a new user and grant permissions in MySQL mysql grant user access to database mysql create user with password mysql grant all privileges to root create user mysql mysql delete user mysql create user example
Views: 83 Hindi Life
Enable run/edit as administrator to open a file/folder in Ubuntu 18.04,17.10 & 16.04
 
03:34
How to Enable run as administrator to open a file in Ubuntu 18.04 17.10 & 16.04. How to run as Root in Ubuntu. How to ubuntu 16.04 open as root. How to open file manager as root ubuntu. How to open file as root ubuntu terminal. How to ubuntu 16.04 file manager as root. How to Ubuntu open as administrator. how to enable run as administrator in Ubuntu. #runasadministrator #ubuntu #enableroot Do not forget to subscribe my channel its motivate me. Thanks for watching. Background Music used Track:Cartoon - On & On (feat. Daniel Levi) [NCS Release] Music Provides by NoCopyrightSounds. Watch:https://www.youtube.com/watch?v=K4DyBUG242c Free Download / Stream: http://ncs.io/onandon
Views: 660 SJ Technics
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: 19297 Quick Notepad Tutorial
What happens when you delete linux root directory??
 
03:07
I wanted to see what happens when linux root directory. I tried this on a virtual machine with ubuntu 18.04. Not everything will be deleted. But no command works after the command execution. Watch it yourself.. Check out more on http://umess.me/
Views: 59 Umesh Gangundi
How oracle Optimizes WHERE Clauses - learn oracle tutorial 7
 
13:00
in this video i will show you how to use where clause with his constraints and many more, join our group for more detail,https://www.facebook.com/groups/242999206136244/ The Four main categories of SQL statements are as follows: 1. DML (Data Manipulation Language) 2. DDL (Data Definition Language) 3. DCL (Data Control Language) 4. TCL (Transaction Control Language) -------------------------------------------------------------------------- DML statements include the following: SELECT – select records from a table INSERT – insert new records UPDATE – update/Modify existing records DELETE – delete existing records -------------------------------------------------------------------------- DDL statements are used to alter/modify a database or table structure and schema. These statements handle the design and storage of database objects. CREATE – create a new Table, database, schema ALTER – alter existing table, column description DROP – delete existing objects from database -------------------------------------------------------------------------- DCL statements control the level of access that users have on database objects. GRANT – allows users to read/write on certain database objects REVOKE – keeps users from read/write permission on database objects. -------------------------------------------------------------------------- TCL statements allow you to control and manage transactions to maintain the integrity of data within SQL statements. BEGIN Transaction – opens a transaction COMMIT Transaction – commits a transaction ROLLBACK Transaction – ROLLBACK a transaction in case of any error. ------------- .---------------------------------------------------------------------------------------------------------. video courses- list of playlist : tips and trics link► https://www.youtube.com/playlist?list=PLOfLYVXrwqXrI5jvwUEi6N13QR4xCj2k2 command prompt commands: link►https://www.youtube.com/playlist?list=PLOfLYVXrwqXobXGUdGk6JhzyQ216dNiQL oracle sql: link►https://www.youtube.com/playlist?list=PLOfLYVXrwqXqoUWCoh4cARGDW13SofDO- c programming: link►https://www.youtube.com/playlist?list=PLOfLYVXrwqXrZ_Ub8EXeLY7YP1YxhoJzf .-----------------------------------------------------------------------------------------------------------. watch more videos: learn oracle sql online overview tutorail : https://www.youtube.com/watch?v=Dfesgj4w8QA&t=8s how to fix or repair a corrupted usb flash drive or cd card using command prompt: https://www.youtube.com/edit?video_id... how to copy a folder using cmd: https://www.youtube.com/watch?v=Lblhb... how to move a folder using cmd: https://www.youtube.com/watch?v=YFfHZ... how to dell files in cmd: https://www.youtube.com/watch?v=3-lqg... how to make and remove directory: https://www.youtube.com/edit?video_id... how to change color and title in cmd: https://www.youtube.com/edit?video_id... how to change directory in command prompt: https://www.youtube.com/watch?v=SmLYx... .-----------------------------------------------------------------------------------------------------------. social media links: join our group: ► https://www.facebook.com/groups/24299... ► Follow on Google+: http://[email protected] ► Follow on Twitter: https://twitter.com/@rananavi4766669 :
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: 311 Praveen Biyyapu
Android Studio IDE: KVM Device | ADV
 
02:02
Get(Free,Donate) W: /dev/kvm device: permission denied. W: KVM is required to run this ADV. /dev/kvm device: permission denied. Grant current user access to /dev/kvm. #Android IDE(Window, Mac, Linux): https://developer.android.com/studio/index.html #Configuring VM acceleration on Linux https://developer.android.com/studio/run/emulator-acceleration.html?utm_source=android-studio#vm-linux #Command $sudo apt-get install qemu-kvm libvirt-bin ubuntu-vm-builder bridge-utils # NO "ia32-libs-multiarch" #Add Permission to KVM $sudo adduser username libvirtd $sudo adduser username kvm #for me: just add for kvm,(maybe need libvirtd). #Logout and Login to DONE.
Views: 7963 Linus PvP
How to grant execute permissions on a SQL Server 2017 Database
 
05:57
Don't forget to subscribe to our channel. https://www.youtube.com/tricksthatmakesmart https://www.facebook.com/tricksthatmakeyousmart https://www.facebook.com/groups/tricksthatmakeyousmart
#7 linux tutorial for beginners-Unix Security Model and Utilities-II
 
01:14:40
linux tutorial for beginners 6 Unix Security Model and Utilities-II. To Learn or Teach Linux visit www.theskillpedia.com, A Marketplace for Learners and Trainers. For Corporate Training Requirements Visit My Website www.rnsangwan.com Slides Contents The Linux Security Model Users and groups are used to control access to files and resources. User log in to the system by supplying their user name and password. Every file on the system is owned by a user and associated with a group. Every process has a owner and group affiliation, and can only access the resources it’s owner or group can access. Users Every user of the system is assigned a unique User ID number. Users’ names and uids are stored in /etc/passwd Users are assigned a home directory and a program that is run when they log on. User cannot read, write or execute each others’ files without permission. Groups Users are assigned to groups with unique group ID numbers. gids are stored in /etc/group. Each user is given their own private group. They can also be added to other groups to gain additional access. All users in a group can share files that belong to the group. The primary group can be changed using the newgrp command. The root user The root user: a special administrative account. Sometimes called the superuser. root has complete control over the system. An ultimate capacity to damage the system. You should not log in as root without a very good reason. Normal users’ potential to do a damage is limited. Linux File Security Every file and directory has permissions set that determine who can access it. Permission are set for: The owner of the file The group members All others Permissions that are set are called read, write, and execute permissions. Permission Types Four symbols are used when displaying permissions: r permission to read a file or list a directory’s content w permission to write to a file or create of remove files from a directory. x permission to execute a program or change into a directory and do a long listing of the directory. - no permission A file may be removed by anyone who has write permission to the directory in which the file resides regardless of the ownership or permissions on the file itself. The first character of the long listing is the file type. Linux Process Security When a process accesses a file the user and the group of the process are compared with the user and group of the file. If the user matches, the user permission apply. If the group matches, but the user doesn’t, the group permission apply. If neither match, the other permissions apply. Every process runs as a under the authority of a particular user and with the authority of one or more groups, this is called the process’s security context. Changing Permissions- Symbolic Method To change access modes: chmod -R mode file… Where mode is: u,g or o a : for user, group and other + or – : for grand or deny r,w or x : for read, write and execute Examples: ugo+r Grant read access to all. o-wx Deny write and execute to others. Multiple comma separated operations can be give in a single command Changing permissions- Numeric Method Uses a three-digit mode number. First digit specifies owner’s permissions. Second digit specifies group permissions. Third digit represents other’s permissions. Permissions are calculated by adding: 4 for read 2 for write 1 for execute Example: chmod 640 sangwan.dat Configuring the Bash Shell The Shell is configured through a variety of mechanisms: Local Variables Aliases and functions The set and shopt commands The shell can also configure other commands or applications through environment variables. Variables A variable is a label that has a value. Used to configure the shell or other programs. Variables are resident in memory. Two types: local and environment Local Variables are used only by the shell. Environment variables are passed onto other commands. Display variables and values using: set to display all variables. env to display environment variables. The set, env and echo commands can be used to display all variables, environment variables, and a single variable value, respectively. $ set | more $ env | less $ echo $HOME $ HOME=/home/abi; export HOME $ echo $HOME Configure the Shell: Local Variables Data in Shell scripts and environment settings stored in variables. Conventionally all upper-case. Setting variable value: $FAV_COLOR=blue To retrieve variable value, use $ before the variable name $echo $FAV_COLOR blue For a list of variables that configure the shell, see the Shell Variables section of the bash man page. Common Local Variables
Views: 2208 TheSkillPedia
How to apply for a QLD Government - Small Business Digital Grants
 
13:19
In this video, I reveal how easy it is to apply for a Queensland government small business digital grant.