Home
Search results “Grant oracle create directory”
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: 1938 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: 32893 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: 4637 Data Science Center
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: 1376 dbaforbeginners
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') );
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: 198 Rinku Kumar Singh
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: 22162 Manish Sharma
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: 1232 hammadshams
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: 47732 Udacity
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: 45809 jbleistein11
[ORCLS01E02 ] Creating Oracle Database Objects Part 1
 
33:01
Creating Oracle Database Creating Oracle table Primary key
Views: 280 joey de jesus
Creating Tablespace using Oracle Enterprise Manager
 
05:02
STEPS: 1. Login into Enterprise manager 2. click on server tab - tablespace 3. inside tablespace window you can found default tablespace Example Sysaux System Temp Undo Users Now we going to create our own table-space, To create a new tablespace just click create button on right hand side 4. Now enter Tablespace name, Select extent management type as: Local Type: you can select permanent , temp, undo NOTE: Permanent tablespace:- Data persistent beyond duration of a session or transcation, objects in permanent tablespaces are stored in datafile. Temporary tablespace:- It contain objects only for a session or transcation, objects are stored in temp files Undo tablespacee:- It store data permanently, it important role is to provide read consistency for SELECT statement. the ability to rollback a transcation if it is failed to commit. Status: read,write mode 5. Click on add button to add datafile give name for datafile, size then give ok Thank you for watching Blog:- http://ramprasath91.blogspot.in/
Views: 3932 TechWizard
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: 60226 Manish Sharma
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: 1218 Progtips 4 Devs
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: 4932 jbleistein11
Linux Training - HOW TO Create Users and Groups in Linux
 
10:08
This Linux video tutorial from https://www.fireboxtraining.com/linux demonstrates how to create users and groups on a Linux server. We will take a closer look at the /etc/passwd and /etc/group files so you better understand the relationship between users and groups.
Views: 64617 Firebox Training
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: 500 khaled alkhudari
Oracle -11g -Sql -Create table in Database -1
 
10:01
Khunkhun Product 1-SQL TYPE -DDL(CREATE ,ALTER,DROP ) ,DML (INSERT ,UPDATE,DELETE), DQL(USED TO RETRIVE THE DATA FROM TABLE FOR READ ONLY PURPOUS) , DCL(GRANT,REVOKE) ,TCL(COMMIT,ROLLBACK) 1 HOW TO CREATE A TABLE- 2- Insert the Record 1-DDL – Data Definition Language 2-DML –Data Manipulation Language 3- DQL-Data querying Language 4-DCL-Data Control Language 5-TCL –Transction Control Language
Views: 253 khunkhun Product
creating tablespace in oracle 12c
 
01:44
As Oracle has evolved, the options for creating tablespaces have grown more complex, with more CREATE TABLESPACE options: You create tablespaces with the CREATE TABLESPACE command. Before you create the tablespace you should decide: 1. How big you wish the tablespace to be. 2. Where you want to put the datafile or datafiles that will be associated with that tablespace. 3. What you want to call the tablespace and the datafiles. We recommend that you include the following in the datafile name when you create the tablespace: 1. The name of the database 2. The name of the tablespace 3. A number that makes the datafile unique So, for a tablespace called USERS assigned to a database called BOOKTST we would have a datafile called booktst_users_01.dbf. Here is an example of creating such a tablespace using the create tablespace command: Note that we used 50m to indicate that we wanted to create the tablespace 50 Megabytes in size. You can also use the K symbol for Kilobytes, and the G symbol for Gigabytes. If you want to try to use the P symbol for a 50 Petabyte tablespace, we want to talk to you! There are several "create tablespace" options that determine how big the tablespace will be: Autoextend on: Creating a tablespace with autoextend on alleviates the potential problem of a database outage if the tablespace reaches maximum extents. You create a tablespace using autoextend with the autoextend on option. Using "create tablespace . . . autoextend on" will push the point of failure to the OS filesystem, which is good because you never want you database to hang because a tablespace cannot grow. With autoextend on, you only need to monitor the free space in the filesystem directory. Maxsize: This is the maximum size that the datafile can grow. We recommend creating a tablespace with maxsize unlimited to prevent a lock-up. Size: This is the size of the underlying data file for the tablespace. Blocksize: Specifying a larger blocksize will not result in a larger tablespace. See here on creating tablespaces with non-default blocksizes. Uniform size: This specifies the size that the data file will grow when it needs to extend. By default, an Oracle tablespace will not grow if it runs out of space. If you use up all your space, you are just out of luck unless you use the autoextend keyword to indicate that the tablespace may grow, on it?s own, dynamically. Here is an example of creating a tablespace that is set to autoextend:
Views: 4739 Mohammad Taseen
Oracle DB - Create Tablespace
 
07:16
Oracle DBA Tutorial by TechSQL Oracle DB - Create Tablespace
Views: 931 techsql
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: 13639 Quick Notepad Tutorial
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: 97 Vídeos Aulas TI
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: 142323 furulevi
ORACLE: GRANT BASIC PERMISSIONS TO USER.
 
07:11
ORACLE USING COMMANDS IN SYSTEM DASHBOARD TO ENABLE A USER LOGIN CREDENTIAL.WITHOUT SESSION THE USER WILL NOT BE ABLE TO DO LOGIN AND ANY OTHER RELATED THINGS LIKE CREATE,DELETE ETC. PRACTICAL BY itechsolution.
Views: 15 itechsolution
Restaurant Management Software : How to Create User Roles ? - Semalt
 
01:33
Visit us - https://semalt.com/?ref=y #how_to, #management, #restaurant, #roles, #software, #create, #user, #how, #to, #ifilosemyself_create, #bjp_to, #prachifam_software, #legenda_user, #boston_restaurant how to create user roles wordpress create user roles user management roles how to create user roles in wordpress how to create user roles in joomla how to create user roles in oracle how to create user roles in sap user roles software how to create user application software how to create user friendly software create user roles joomla create user roles oracle mongodb create user roles pgadmin create user roles create user roles php postgresql create user roles wp create user roles create table user roles create user roles wordpress create user roles drupal create user roles mysql oracle create user roles postgres create user roles how to create user roles in active directory how to create hospital management software how to create library management software how to create database management software how to create user roles in asp net how to create user wordpress user roles management asp.net user roles management user access management roles oracle user management roles drupal user management roles devise-roles-user-management java user roles management how to create derived roles yii user management roles how to create user management in php how to create user management in wordpress postgres create user vs create roles postgresql create user vs create roles user roles software development how to create a software user manual how to create user manual for software software user roles matrix software to create user account software to create user interface software to create user manuals create custom user roles wordpress drupal create user programmatically roles create user roles in asp.net oracle 11g create user roles create user roles sql server how to define management roles create user roles in sap oracle sql create user roles dscl create system user roles oracle umx create user roles sql server create user roles wordpress create new user roles how to create user roles in sql server 2008 create user roles drupal 7 sbs 2011 create user roles create user roles in oracle oracle create user grant roles how to create a software management database how to create a library management software software how to create how to software create how to create software user management software software user management management software user software configuration management roles software quality management roles software release management roles how to create restaurant how to create user in sql management studio how to create user in sql 2012 management how to create user manual for database management how to create user linux how to create user forums how to create user group how to create user guide how to create user in how to create user flows how to create user personas how to create mysql user how to create user control how to create database user how to create user directories how to create xdb user how to create subversion user pgadmin how to create user oracle how to create user how to create samba user how to create user account how to create user profiles how to create user profile proftpd how to create user how to create dcom user how to create sql user how to create unix user how to create user mysql how to create the user how to create user accounts how to create user dsn db2 how to create user how to create ssh user openvpn how to create user management roles management roles how to create domain user how to create sysdba user how to create redhat user how to create limited user how to create user stories how to create ftp user how to create super user how to create user documentation mysql how to create user how to create clamav user how to create smtp user how to create user story how to create user oracle roundcube how to create user how to create a user samba how to create user how to create power user how to create user login how to create user ubuntu how to override create user rhel how to create user how to create user manuals how to create user community how to create new user how to create user manual how to customize create user cognos how to create user how to create iis user how to create svn user how to create user controls how to create user authentication how to create user groups how to create user guides how to create olapsys user how to create user interface how to create add user
Views: 3 Ram Kumar
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: 5249 Education Help
SQL Server DBA Tutorial 52- How to create Windows Group Authentication Login in SQL Server
 
08:56
In this video you will learn how to add Active directory group to SQL Server, how to create login using Windows Authentication while selecting the active directory group. How SQL Server communicates with Active directory for Authentication and Authorization. What option to select when adding Active directory (AD) group to SQL Server Login. Video shows both ways of creating Group login, using SQL Server Management studio as well as T-SQL script. Blog post link for the video for scripts used in the video http://sqlage.blogspot.com/2015/03/how-to-create-windows-group.html Visit our website to check out SQL Server DBA Tutorial Step by Step http://www.techbrothersit.com/2014/12/sql-server-dba-tutorial.html
Views: 15547 TechBrothersIT
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: 25195 Hardik Parmar
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: 41 OracleDB Solutions
Часть 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 и не нужен большинству из вас.
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: 38 OracleDB Solutions
SQL Server DBA Tutorial 50- How to create Windows Authentication Login in SQL Server
 
08:09
In this video you will learn how to create SQL Server Login using Windows Authentication. It also demonstrates step by step process of creating Windows Authentication Login using SQL Server Management studio as well as T-SQL Script. It also explains how to retrieve Active directory user, options while creating Windows Authentication user such as selecting right object type, selecting right domain controller as well as selecting entire directory to create SQL Server Login using Windows Authentication. link to blog post: http://sqlage.blogspot.com/2015/03/how-to-create-windows-authentication.html Visit our website to check out SQL Server DBA Tutorial Step by Step http://www.techbrothersit.com/2014/12/sql-server-dba-tutorial.html
Views: 20835 TechBrothersIT
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.
How To Create External Table Using Oracle Loader
 
03:11
This video describes how to create external table in Oracle 12c and also how to create a destination table.
Views: 703 regina nkemchor
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.
How to Create a User and Grant Permissions
 
05:39
In this short tutorial, we show how to create a new user and give her access to a form in your FormSmarts account. We're allowing the user to view form entries online & download a PDF, generate an Excel report and download form attachments.
Views: 1018 formsmarts
Oracle Database 12c: Creating a Role Using Oracle Enterprise Manager Database Express
 
03:42
Demo of how to create a role using EM Express.
Views: 4681 OracleDBVision
Creating bash profile for user oracle
 
01:18
above video shows how to create bash profile for oracle user before installing database software..
Views: 1416 dbaforbeginners
Oracle Cloud - User Creation
 
09:52
How to Create Users and Grant Roles in Oracle Cloud
Views: 177 Rahul Phatak
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: 36537 Abdulhakim Desuki
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: 81046 jbleistein11
Using Roles to Define Who Can Do What
 
02:34
Create a new application role, configure member users to inherit the ability to build and run reports from BI Content Author, and then configure permissions on catalog objects for the new role. 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 © 2016 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.