Home
Search results “Grant oracle database link”
How to Create Database Link in Oracle. /* Step By Step /*
 
17:21
Today I am showing you. How to create Database link (DB Link) in Oracle. What is Database Link ( DB Link ) ? A database link is a schema object in one database that enables you to access objects on another database. I have 2 databases 1. paragdb 2. orcl In Paragdb database 1. Create listener 2. Service Name 3. In Orcl Database 1. Create Listener 2. Service Name 3. Create new User 4.Grant connect,resource,create database link to username; 5. open user 6. create database link 1. create database link link1 connect to scott identified by tiger using 'connect_primary''; 7.select * from [email protected]; 8. select * from [email protected]; 9. views 1. select * from user_db_links; 2. select * from all_db_links; 10. conn sys as sysdba 11. grant public database link to username; 12. select * from dba_db_links; 13. conn username/pass 14. create public database link plink connect to scott identified by tiger using 'connect_primary'; 15. drop database link. drop database link link1; To follow this steps you will also create oracle database link. It is very easy to understand.
Views: 8847 Parag Mahalle
SQL Tutorial - How to grant System and Object Privileges in Oracle Database
 
18:08
In this session I Explaining the Theory of Granting and Revoking System and Object privileges.... #Oracletutorialforbeginners #rmanrecoverytutorial #SQLTutorial #SystemandObjectPrivilegesinOracle by Lalit saini
Views: 12265 Oracle World
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: 66559 Manish Sharma
SQL tutorial 47: How to Grant Object Privileges With Grant Option in Oracle Database
 
07:13
In this SQL Tutorial you will learn How To Grant Object Privilege using Grant Data Control Language (DCL) statement along with GRANT OPTION flag. Third SQL Tutorial in the series of user privileges in oracle database ------------------------------------------------------------------------ ►►►Timeline◄◄◄ 1:06- Query 1- How To grant Basic Object Privilege (i.e.SELECT Object privilege) to a user 3:31- Query 2 - How to Grant Multiple Object Privilege To a user in 4:26- Query 3 - How To grant Object Privilege on Column Level 5:30- Query 4- How To Grant System Privilege WITH GRANT OPTION flag 6:06- WITH ADMIN OPTION demonstration ------------------------------------------------------------------------ Celebrating 1000 subscribers. Thanks a lot guys for all your love and support. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ List of Object Privilege http://bit.ly/list_of_object_privileges Object Privileges Blog http://bit.ly/object_privileges-in-oracle-database Previous Tutorial System Privilege: http://youtu.be/EQzdtKPiErU Introduction to user privilege: http://youtu.be/iQFb86lM1gs ------------------------------------------------------------------------- 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: 24127 Manish Sharma
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: 360499 Chitu Okoli
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: 24382 Manish Sharma
SQL tutorial 45: Introduction to user Privileges in Oracle Database By Manish Sharma RebellionRider
 
04:30
First SQL Tutorial in the series of user privileges in oracle database an introduction to user privileges. In this tutorial you will learn ● What is user privileges ● Different types of user Privileges ● Data Control Language (DCL) Grant and Revoke ● Who Can Grant or Revoke System Privileges? ● Oracle grant flags such as "With Admin option, With Grant option and with hierarchy option " This is a quick video on Introduction of user privileges expaining the theoretical concepts for the better understanding of the concept and up coming videos in USER PRIVILEGE series. Celebrating 1000 subscribers. Thanks a lot guys for all your love and support. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/introduction-to-user-privileges ------------------------------------------------------------------------- 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: 28588 Manish Sharma
Oracle Database Users / User Management (Simple)
 
09:33
Create, Alter, Drop, Grant Rights, Default Tablespace, Temporary Tablespace, Quota Setup, View Users Information, Lock / Unlock user account select username,account_status,default_tablespace, temporary_tablespace,created from dba_users; create user myuser identified by myuser; alter user myuser quota unlimited on mytbs; alter user myuser quota 100m on mytbs; alter user temporary tablespace temp; alter user myuser default tablespace mytbs; alter user myuser accout unlock; alter user myuser account lock; alter user myuser password expire; alter user myuser identified by youuser; create user myuser identified by myuser default tablespace users temporary tablespace temp quota unlimited on users; grant create session, resource to myuser; grant create session, resource to myuser with grant option; drop user asif; drop user asif cascade;
Views: 41709 Abbasi Asif
Oracle DB - Synonyms
 
02:54
Oracle DB - Synonyms Watch More Videos at: https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Parth Panjabi, Tutorials Point India Private Limited
Oracle Database Express Edition (XE) Kullanıcı Oluşturma ve Toad'a Bağlama
 
01:31
sqlplus "/ as sysdba" create user denemeusr identified by sifre; grant CREATE SESSION, ALTER SESSION, CREATE DATABASE LINK, - CREATE MATERIALIZED VIEW, CREATE PROCEDURE, CREATE PUBLIC SYNONYM, - CREATE ROLE, CREATE SEQUENCE, CREATE SYNONYM, CREATE TABLE, - CREATE TRIGGER, CREATE TYPE, CREATE VIEW, UNLIMITED TABLESPACE - to denemeusr; C:\ORA_DS10GR2\NETWORK\ADMIN XXX= (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = localhost) (PORT = 1521) ) (CONNECT_DATA = (SID = XE) ) )
Views: 154 Values
How to installation  Oracle Designer 10 g  and Introduction
 
16:49
دي الصلاحيات المطلوبه لليوزر GRANT EXECUTE ON DBMS_LOCK TO &U; GRANT EXECUTE ON DBMS_PIPE TO &U; GRANT EXECUTE ON DBMS_RLS TO &U; GRANT SELECT ON dba_rollback_segs TO &U; GRANT SELECT ON dba_segments TO &U; GRANT SELECT ON sys.v_$nls_parameters TO &U WITH GRANT OPTION; GRANT SELECT on V_$PARAMETER TO &U; GRANT ALTER SESSION TO &U; GRANT CREATE ANY SYNONYM TO &U; GRANT CREATE SESSION TO &U; GRANT CREATE DATABASE LINK TO &U; GRANT CREATE PROCEDURE TO &U; GRANT CREATE ROLE TO &U; GRANT CREATE SEQUENCE TO &U; GRANT CREATE SESSION TO &U; GRANT CREATE TABLE TO &U; GRANT CREATE TRIGGER TO &U; GRANT CREATE TYPE TO &U; GRANT CREATE VIEW TO &U; GRANT DROP ANY SYNONYM TO &U; GRANT SELECT ANY SEQUENCE TO &U; GRANT CREATE PUBLIC SYNONYM TO &U; grant execute on dbms_lock to &U; grant execute on dbms_pipe to a&U; grant execute on dbms_rls to &U; grant select on dba_rollback_segs to &U; grant select on dba_segments to &u; grant select on v_$nls_parameters to &u; grant select on v_$parameter to &u;
Views: 3821 Ahmed Tartour
Replikasi Database  Membuat Database Link  (SQLPLUS CLI)
 
01:32
YUK JANGAN LUPA LIKE AND SUBSCRIBE :) THANKS FOR WATCHING Tutorial Replikasi Databse 1. Di database ini akan membuat user FUAD yang mempunyai tabel RESTORAN_FUAD dan memberi grant “create database link” ke user FUAD agar bisamembuat db link. 2. Buat TNSName 3. Tampilkan tabel pembeli 4. Buat database link, Query ke tabel di schema FUAD di database RESTORAN, Tambahkan @NAMADATABASE_LINK di belakang tabel/view yang akan di-query. DONE :) MUDAH KAN..
Views: 13 NF Bradda
طريقة تصطيب الديزاينر وعمل مشروع مصغر عليه
 
50:30
دي الصلاحيات المطلوبه لليوزر GRANT EXECUTE ON DBMS_LOCK TO &U; GRANT EXECUTE ON DBMS_PIPE TO &U; GRANT EXECUTE ON DBMS_RLS TO &U; GRANT SELECT ON dba_rollback_segs TO &U; GRANT SELECT ON dba_segments TO &U; GRANT SELECT ON sys.v_$nls_parameters TO &U WITH GRANT OPTION; GRANT SELECT on V_$PARAMETER TO &U; GRANT ALTER SESSION TO &U; GRANT CREATE ANY SYNONYM TO &U; GRANT CREATE SESSION TO &U; GRANT CREATE DATABASE LINK TO &U; GRANT CREATE PROCEDURE TO &U; GRANT CREATE ROLE TO &U; GRANT CREATE SEQUENCE TO &U; GRANT CREATE SESSION TO &U; GRANT CREATE TABLE TO &U; GRANT CREATE TRIGGER TO &U; GRANT CREATE TYPE TO &U; GRANT CREATE VIEW TO &U; GRANT DROP ANY SYNONYM TO &U; GRANT SELECT ANY SEQUENCE TO &U; GRANT CREATE PUBLIC SYNONYM TO &U; grant execute on dbms_lock to &U; grant execute on dbms_pipe to a&U; grant execute on dbms_rls to &U; grant select on dba_rollback_segs to &U; grant select on dba_segments to &u; grant select on v_$nls_parameters to &u; grant select on v_$parameter to &u; تم شرح طريقه التصطيب للديزانير وعمل مشورغ مصغر وكيفيه تصدير الى الداتا بيز
Views: 1227 Ahmed Tartour
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: 37286 Thamizharasan Mohan
Oracle DBA Justin - How to grant a system privilege to a user in an Oracle database
 
11:28
How to grant a system privilege to a user in an Oracle database
Views: 22472 jbleistein11
SQL tutorial 46: What are System Privileges & How To Grant them using Data Control Language
 
06:26
In this SQL Tutorial you will learn How To Grant System Privilege using Grant Data Control Language (DCL) along with ADMIN OPTION flag. First SQL Tutorial in the series of user privileges in oracle database ------------------------------------------------------------------------ ►►►Timeline◄◄◄ 1:50- Query 1- How To grant Basic System Privilege (i.e.Create Table system privilege) to a user 2:40- Query 2 - How to Grant Multiple System Privilege To a user in Single Grant (Data Control Language) Statement 3:52- Query 3 - How To grant System Privilege To Multiple Users in Single Grant (Data Control Language) Statement 4:50- Query 4- How To Grant System Privilege WITH ADMIN OPTION flag 5:26- WITH ADMIN OPTION demonstration ------------------------------------------------------------------------ Celebrating 1000 subscribers. Thanks a lot guys for all your love and support. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog (Link for SQL Script is at the end of this article) : http://bit.ly/system_privilege_admin_option Link for How To create user ●SQL Tutorial 37 - Using Create User Statement http://youtu.be/4QbK2Y-1LZw ●SQL Tutorial 38- Using SQL Developer http://youtu.be/GS4udgR44Ls ●SQL Tutorial 39- Using Oracle Enterprise Manager http://youtu.be/zGjh-Bb3HrI List of few System Privileges Available in Oracle Database http://wp.me/p3r6sw-7M Previous Tutorial: Introduction To User Privileges http://youtu.be/iQFb86lM1gs ------------------------------------------------------------------------- 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: 25204 Manish Sharma
SQL tutorial 43: How to create an EXTERNAL USER in oracle database By Manish Sharma RebellionRider
 
05:08
Learn another DBA trick. In this tutorial you will learn how to create an user actually an External user / schema. Being an Oracle DBA you must know how to create an external user/ schema Celebrating 1000 subscribers. Thanks a lot guys for all your love and support. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Website: http://bit.ly/how-to-create-external_user-oracle Previous Tutorial: How to unlock user using SQL Developer http://youtu.be/xRBfeTO1Pc8 Tutorial 38: http://youtu.be/GS4udgR44Ls Links of how to create user tutorial Create user using SQL Developer http://youtu.be/GS4udgR44Ls Create user using Create user command http://youtu.be/4QbK2Y-1LZw Create user using EM http://youtu.be/zGjh-Bb3HrI ------------------------------------------------------------------------- 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] -------------------------------------------------------------------------- ►Connect with me on my LinkedIn and please endorse my skills Thanks in Advance http://in.linkedin.com/in/mannbhardwaj/ -------------------------------------------------------------------------- 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: 19352 Manish Sharma
How to Create SCOTT Schema and default tables in Oracle Database 11g
 
04:31
If there is no Oracle default scott schema is available after the installation of Oracle 11g database in windows, Then how to create the scott schema and the default tables like emp , dept, bonus, salgrade in database. Here is a easy step by step tutorial to create it in your database. Follow these Steps One By One. File Download Link: https://sites.google.com/site/gpabukcbyarshman/gpa-semester-wise/oracle.zip?attredirects=0&d=1 For More...!! Facebook.Com/MrArshman
Views: 2028 Arshman Saleem
Oracle Database 12c Tutorial 3:Connect HR/SYS user with SQL Developer in Oracle12c Using TNS Service
 
05:24
Learn how to connect HR and Sys User of Oracle database 12c With SQL Developer using TNS service. Connect HR user which is in pluggable database to SQL Developer ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : Previous Tutorial ► Tut 61: How To Unlock HR schema in Oracle Database 12c http://youtu.be/F81gfUnznZY ------------------------------------------------------------------------- ►►►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: 55437 Manish Sharma
Adding a User to Oracle - Full Schema Access, But Read only
 
17:04
Hi friends this video will help you in live environment when you need read only access of other schema object procedure , function packages etc.#AddingaUser #FullSchema #oracle Oracle database Unbeatable,Unbreakable Platform..
Views: 1769 Oracle World
Connect to Remote Oracle database using Oracle Sql Developer on Windows.
 
19:40
Three methods of connection to oracle database using sql developer in Windows Operating System, is demonstrated in this online video. 1. Connect using general settings with database service name. 2. Connect by importing xml configuration file. 3. Connect using connection string with jdbc thin client. Oracle SQL Developer download link : http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html
Views: 19631 Subhroneel Ganguly
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;
Grants With Admin Option - Create roles in Oracle 12c Part - 2
 
13:03
It becomes difficult for DBA to handle granting privileges when there are tons of requests. With admin option is a wonderful feature which reduces stress of db admin and user gets authority to grant specific privileges to other user, this is the pros side and cons is un ethical use of the privileges by certain users. It is necessary for DB admin to monitor activities of users whom this privileges are provided.
Views: 237 Subhroneel Ganguly
Connect To SQL Server Database Over Network - Enable Network Access in SQL Server
 
05:59
Buy Redmi 6 Pro (Gold, 32GB) - https://amzn.to/2Ntpkv4 Redmi Y2 (Gold, 3GB RAM, 32GB Storage) - https://amzn.to/2BXkNie Redmi 6 Pro (Black, 32GB) - https://amzn.to/2NofTwN Redmi 6 Pro (Gold, 64GB) - https://amzn.to/2BXMJmm Redmi Y2 (Black, 32GB) - https://amzn.to/2NqoHlV OnePlus 6 (Mirror Black, 6GB RAM, 64GB Storage) - https://amzn.to/2NrqtDb Redmi Y2 (Dark Grey, 3GB RAM, 32GB Storage) - https://amzn.to/2BXwvcS Redmi 6 Pro (Black, 64GB) - https://amzn.to/2OauUHV Connect To SQL Server Database Over A Network, connect to sql server database via LAN, Enable Network Access in SQL Server Database, Enable Remote Connection In SQL Express, Enable Remote Connection Over Network, Connect To SQL Server Database, Configure SQL Server To Allow Network Connection, Connect To SQL Server Database Over A Network Using Management Studio, Sharing a Database on a Local Area Network, SQL Server Database, SQL Server Allow Remote Connections to SQL Server Express, Allow Remote Connections to SQL Express, Allow Remote Connections to SQL, Allow Remote Connections To MSSQL, Remote Connections To SQL Express Verbinden mit SQL Server-Datenbank über Netzwerk - Aktivieren Sie den Netzwerkzugriff in SQL Server Conectarse a la base de datos de SQL Server a través de la red: habilitar el acceso a la red en SQL Server Connessione al database SQL Server tramite rete: abilitare l'accesso alla rete in SQL Server Se connecter à la base de données SQL Server sur le réseau - Activer l'accès au réseau dans SQL Server Подключение к базе данных SQL Server через сеть - включение сетевого доступа в SQL Server Podklyucheniye k baze dannykh SQL Server cherez set' - vklyucheniye setevogo dostupa v SQL Server 通过网络连接到SQL Server数据库 - 在SQL Server中启用网络访问 Tōngguò wǎngluò liánjiē dào SQL Server shùjùkù - zài SQL Server zhōng qǐyòng wǎngluò fǎngwèn ネットワーク経由でSQL Serverデータベースに接続する - SQL Serverでネットワークアクセスを有効にする Nettowāku keiyu de SQL sābā dētabēsu ni setsuzoku suru - SQL sābā de nettowākuakusesu o yūkōnisuru Conectar-se ao banco de dados do SQL Server pela rede - habilitar o acesso à rede no SQL Server Anslut till SQL Server Database över nätverk - Aktivera nätverksåtkomst i SQL Server
Views: 72448 Admin Technomark
Oracle Database11g tutorials 14 : How to CREATE TABLE using sql developer and command prompt
 
08:36
Oracle Database11g tutorials 14 How to Create table using command prompt and Create table using sql developer Blog Link http://bit.ly/1TkY4Oe Time Line 0:25 Introduction of Tables in Database 1:03 What is Create Table (Introduction of create table) 1:30 Syntax of Create Table 2:08 How to create table using Command Prompt 4:55 How to create table using SQL Developer Links for Oracle Database tutorials 4: database connectivity using SQL developer and command prompt http://youtu.be/wSqoXRlXDUU You can have indepth knowledge about SQL create table here http://www.rebellionrider.com/sql-create-table.html Tool used in this tutorial is command prompt. This tutorial series is part of SQL expert exam certification training. if you are preparing for SQL certification you can use my tutorials. This SQL Tutorial is a part of free training. Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=j7eYO7 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 linking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com Today in this oracle database tutorial we will see How to CREATE A TABLE. if we have to define a table in layman language then we can say that Tables are just a collection of Rows and Columns but In RDBMS tables are database objects which help in organizing data into ROWS and COLUMNS. We can also say that SQL tables are kind of data structure which are used by database for efficient storage of data. To create a table in our database we use SQL CREATE TABLE command. SQL CREATE TABLE is a type of DATA DEFINITION LANGUAGE also known as DDL. To Create a table in your schema you will require CREATE TABLE system privilege. In our future videos we will see what are system and object privileges and how to grant them to a user. Today for this video we will be using Sample schema HR which already has all the necessary privileges. Ohk Let's see the syntax. CREATE TABLE table name ( column name1 Data-Type(size), column name2 Data-Type(size), ..... ); CREATE TABLE is an oracle reserved word or say an Oracle key word whereas There are 3 different ways of creating a table in Oracle database. Creating a table using Command Line Interface (CLI) in Oracle database For demonstrating how to create table in oracle database using CLI, I'll be using Command prompt. Thats how we create table using command prompt. you can check your table structure by DESCRIBE command for that just write DESC and your table name. Like this Another way of creating a table is by using Graphic user interface (GUI) in Oracle database To demonstrate how to create table using GUI we will use SQL developer. Lets open our SQL developer I am connected to HR schema if you do not know how to create a connection to database using SQL developer please watch my oracle database tutorial 4 that explains database connectivity using SQL developer and command prompt. Link for this video is in the description below. So lets create a table. Creating a table using SQL developer is very easy we do not have to fire any query here. Let's start First of all right click on your connection in which you want to create a table and choose schema browser. This will open a separate schema browser pane or you can expend your connection by clicking this + sign and then right click on table and choose New Table. However I prefer working with schema browser so let's skip to schema browser pane here from the first drop-down list you can choose connection name and in the second drop down list you can choose what database objects you want to work with we want to create a table thus I'll choose table and then click this arrow here and choose option for new table Ok we have created a table wizard first of all give a unique name to your table and add some column as well. For this, click the green plus button. Now we already have a column so give it some name. Also choose a datatype from the list and specify any size you can check this not null column if in case you want to make this a mandatory column you can also specify default value and constraint If you want to make this column a primary key you can click here In my future video i'll show you what are these constraints and different ways of applying them on a column in a table. for this video we will concentrate on create table only so when you are done with all your columns click ok Thats your table You can double click on your table here and can see its structure. Thats it
Views: 183080 Manish Sharma
Create Dynamic Link on Oracle APEX based on User Input
 
08:03
This video gives illustration of creating a dynamic link based on user input on a input form. Every time input added, the link will added also. Step by Step tutorial can be found here: http://www.developapex.com/2018/04/how-to-store-application-link-on-oracle.html
Views: 5868 Boby Siswanto
How to access sql server database from another computer (New)
 
08:54
how to access sql server database from another computer in lan!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! cccccccccccccccccc--CONTECT--cccccccccccccccccccccccc 🌐WhatsApp :+919563273765 🌐Youtube Channel:https://www.youtube.com/channel/UCciolV_TinVG39d0S4c1g4w 🔊 LIKE ➡ SHARE ➡ SUBSCRIBE ----------------------------------------------- ((()))-------------------------------------------------- sharing sql server database over network how to access sql server database from another computer how to share sql database between two computers how to make sql server available on the network how to configure sql server 2008 to allow network connections configuring sql server to allow remote connections how to access sql server database from another computer in c# how to connect to remote sql server database from management studio how to share sql database on network how to share mysql database between two computers how to access sql server 2008 database from another computer how to access sql server database from another computer in c# how to configure sql server 2008 to allow network connections how to connect to remote sql server database from management studio how to make sql server available on the network how to access sql server 2012 database from another computer -~-~~-~~~-~~-~- Please watch: "Untitled Project" https://www.youtube.com/watch?v=oQllmOhLzPo -~-~~-~~~-~~-~-
Views: 75667 Engineering Classes
Oracle username and password and Account unlocking
 
08:37
all education purpose videos
Views: 282609 Chandra Shekhar Reddy
ADODB connection in visual basic (vb6) with oracle database
 
09:30
This video briefly explains ADODB connection in vb6 using ADO for data bases to oracle database
Views: 36794 Vijay Thombre
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: 49197 jbleistein11
MySQL Workbench Add User and Connect to Database
 
04:21
Learn how to add a new user and connect to the database using MySQL workbench. Open MySQL Workbench tool and load MySQL connection window from top menu Database and Connect to Database. Use Hostname, port number, 'root' username, click OK and enter the 'root' username password to connect to database server. Once we are logged in to the database server, in the left hand column window, under 'Management' menu, there is a link for 'Users and Privileges' window. Open the 'Users and Privileges' window. Click the bottom 'Add Account' button to add a new user, which opens a new window to enter new user details. Fill out the details and click 'apply' button to save the new user. Close the active session by clicking this cross icon, and now connect to the database server again using the new user details. Enter new user information, press OK and enter the new user password. If you successfully logged in to to MySQL database server, you will see MySQL Workbench default window. Check out the whole playlist of MySQL Workbench Introduction Tutorials or Individual video from the following links, MySQL Workbench Tutorial: Introduction to MySQL Workbench for Beginners Playlist https://www.youtube.com/watch?v=aGQ7PGZ1u24&list=PLhwzZMYRiUEq5e5TJCznKVuPAsnNzT8k5 MySQL Workbench: Understand What is MySQL Workbench? https://www.youtube.com/watch?v=aGQ7PGZ1u24 MySQL Workbench Add User and Connect to Database https://www.youtube.com/watch?v=P7whjxMqYU4 MySQL Workbench Create, Alter, Drop Database https://www.youtube.com/watch?v=1qzE6SN8AZU MySQL Workbench Create, Alter, Drop Table https://www.youtube.com/watch?v=luBmETAk30k MySQL Workbench Insert, Read, Update, Delete Data Rows https://www.youtube.com/watch?v=qb7abQ6ROy4 MySQL Workbench Database Export and Import https://www.youtube.com/watch?v=Jvul-wr-_Bg Subscribe to my channel: https://www.youtube.com/channel/UCvrq9OowoORTV5Gs_jpADhw
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: 85819 Manish Sharma
Tutorials#76  How to create  SYNONYM in Oracle SQL Database
 
07:11
Explaining How to create Synonym in Oracle SQL Database or what is a synonym in SQL or synonym in SQL Server A synonym is an alternative name for objects such as tables, views, sequences, stored procedures, and other database objects. Assignment: Assignment link will be available soon: In this series we cover the following topics: SQL basics, create table oracle, SQL functions, SQL queries, SQL server, SQL developer installation, Oracle database installation, SQL Statement, OCA, Data Types, Types of data types, SQL Logical Operator, SQL Function,Join- Inner Join, Outer join, right outer join, left outer join, full outer join, self-join, cross join, View, SubQuery, Set Operator. follow me on: Facebook Page: https://www.facebook.com/LrnWthr-319371861902642/?ref=bookmarks Contacts Email: [email protected] Instagram: https://www.instagram.com/equalconnect/ Twitter: https://twitter.com/LrnWthR #equalConnectCoach #rakeshmalviya
Views: 119 EqualConnect Coach
SQL tutorial 41: How to UNLOCK USER in oracle Database
 
04:13
SQL tutorial on How to unlock user or schema in oracle database or how to unlock hr account/user/schema in oracle database using alter user SQL command. you can use the steps to change the password of any user in oracle database explained in detail. Celebrating 1000 subscribers. Thanks a lot guys for all your love and support. ------------------------------------------------------------------------- Blog Link: http://bit.ly/unlock-user-in-oracle -------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the first one to see my ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 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/ 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: 39795 Manish Sharma
create user and grant privileges in oracle sql programming language
 
06:13
create user and grant privileges in oracle sql programming language
Views: 710 Vijay dubey
TUTORIAL-1 Create, insert, delete, drop  operations in sql developer oracle 12c with subtitles
 
08:26
first see the syntax 1)CREATE TABLE tablename(fields and its data type) 2)INSERT INTO tablename VALUES(values with same data type) 3)DELETE FROM tablename WHERE condition 4)DROP TABLE tablename
Views: 5217 Let's Learn Pro
Programming in Visual Basic .Net How to Connect Access Database to VB.Net
 
19:11
🎥 Programming in Visual Basic .Net How to Connect Access Database to VB.Net 🙏 Visit my page: https://www.facebook.com/CodeAMinute // ** // 🎉 7 MILLION VIEWS! | THANKS FOR WATCHING! 🎉 🙏 I CAN'T BELIEVE WE'VE HIT 7 MILLION VIEWS ON THIS VIDEO: "Programming in Visual Basic .Net (VB.Net) How to Connect Access Database to VB .Net" ⚡ See the 7 million views Freedom Video ➜ https://youtu.be/cwDqjmSmtMQ 🚀 Here are all of the related (premium) tutorials: ➜ http://bit.ly/2OsJJko 🎬 For C# version, please check out this playlist: ➜ Visual C# .Net and Access Database (C# Premium Tutorials) : Workshop for Complete Beginners. ➜ http://bit.ly/2Q8w0Vx 🙏 Subscribe for more ➜ http://bit.ly/2zAg8Ag Thank you for ALL the likes, comments and subscribes and making this dream a reality! 💯 THANK YOU SO MUCH! 💯 // ** // 🎗 If you would like the source code and project file. Please donate me via PayPal. 💸 https://paypal.me/CodeAMinute/499 🎗 Happy New Year 2019 Promotion! 💸 https://paypal.me/CodeAMinute/199 (USD Only) 📝 Please contact me: [email protected] // ** // 📍 [-Online Programming Course-] 📍 🎓 Please check out my online course on Udemy: Visual Basic .Net, Access Database, EAN-13 Barcode Generator and Crystal Reports, using a Project-Based Approach. ➜ "The Point Of Sale (POS) System". 🌟 Enroll Now. You can get started on your first lesson right away 🌟 🛒 http://bit.ly/2FbmnjY 📝 Note: Thai Audio Only : English subtitle coming soon! // ** // ⛳ Follow me around ⛳ ✔ Want to get updates on new courses or other cool free stuff? Just follow me on social media if that's your thing! Twitter 📍 https://twitter.com/#!/IBasskung Facebook (3) 📍 https://www.facebook.com/CodeAMinute 📍 https://www.facebook.com/IbasskungTutorial 📍 https://www.facebook.com/IbasskungGuitar Google+ (2) 📍 http://google.com/+iBasskung 📍 https://plus.google.com/u/0/107523775437712370629/posts YouTube Channel 📍 https://www.youtube.com/c/iBasskung 📍 Free source code can be found here ➜ https://goo.gl/UNNzp2 💯 THANK YOU SO MUCH! 💯 #vb #vbnet #visualbasic #visualbasicdatabase #RetailPOS #PointOfSale #POS #EmployeeTrainingManagement #EmployeeManagement #EmployeeManagementSystem #EmployeeTrainingRecords #PersonnelManagement ##PersonnelManagementSystem #BankManagementSystem #BankingManagementSystem #BankManagement #Software #javaforandroid #CodeAMinute #iBasskungTutorial #VisualCSharp #CSharp #Programming #MicrosoftAccess #AccessDatabase #SQLServer #MySQL #SQLite #phpMyAdmin #CrystalReports #EAN13BarcodeGenerator #Udemy #OnlineCourses #YouTube // ** // English Tags: vb vb.net visual basic visual basic access access database visual basic database how to connect database to vb.net how to connect access database to visual studio 2010 how to connect database to visual basic 2010 how to connect microsoft access database to visual basic 2010 programming in visual basic .net how to connect access database to vb.net database connectivity in vb.net vb.net login using access database vb.net login form using access database login form in vb.net with database access visual studio access database vb.net connect to database vb.net connect to access database Thai Keywords: เรียน เขียน โปรแกรม สอน เขียน โปรแกรม เขียน โปรแกรม vb.net สอน เขียน โปรแกรม ออนไลน์ เขียน โปรแกรม vb เรียน โปรแกรมเมอร์ โปร เจ ค จบ เขียน โปรแกรม ขาย สินค้า เรียน เขียน โปรแกรม ที่ไหน ดี โรงเรียน สอน เขียน โปรแกรม การ เขียน โปรแกรม visual basic
Views: 10392697 iBasskung
SQL tutorials 15 || How To CREATE TABLE using enterprise manager 11g
 
06:05
Blog Link How to create table : http://www.rebellionrider.com/sql-create-table.html How to create table using Enterprise manager 11g SQL tutorial for beginners with examples on How to create table using enterprise manager 11g This is the third way of creating a table in oracle database. If you are working or oracle express edition Then I am sorry This will not work on Oracle express Edition. Tool used in this tutorial is command prompt. This tutorial series is part of SQL expert exam certification training. if you are preparing for SQL certification you can use my tutorials. This SQL Tutorial is a part of free training. Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=j7eYO7 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 linking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com
Views: 76726 Manish Sharma
03 Installing Oracle 11G Express Edition and Schema Creation
 
09:37
In this video we are going to see how to install Oracle 11G Express Edition, Schema creation and use with IBM Sterling Order Management System Link : http://activekite.com Register : http://activekite.com/wp-login.php?action=register Welcome to ActiveKite.com Google Search String : oracle 11g express edition free download Download Link : http://www.oracle.com/technetwork/database/database-technologies/express-edition/downloads/index.html ----------------------------------- Create Schema ----------------------------------- create user sterling94 identified by sterling94; --grant privileges: grant create session, alter session, create any sequence, alter any sequence, create procedure, create synonym to sterling94; grant create table, create trigger, create type, create view, delete any table, execute any procedure, execute any type to sterling94; grant connect, insert any table, select any dictionary, select any sequence, update any table to sterling94; grant select_catalog_role to sterling94; create bigfile tablespace sterts_01 datafile 'sterts_f1.dat' size 100M autoextend on; alter user sterling94 default tablespace sterts_01 quota unlimited on sterts_01;
Views: 339 ActiveKite
How to create user in Oracle
 
03:23
How to create new Account/User in Oracle? Example: ungtien_promotion / ungtien1q2w3e#$ Step1: login DB: 10.225.6.135: PUB with account DBA to create new account Step 2: execute these command as below --- create tablespace “arct” create tablespace ungtien_promotion datafile '+DATA' size 1g; --- create user on DB create user ungtien_promotion identified by ungtien1q2w3e#$ default tablespace ungtien_promotion ; grant unlimited tablespace to ungtien_promotion; grant create database link, CREATE ANY VIEW, CREATE SEQUENCE, CREATE JOB, CONNECT, RESOURCE, CREATE ANY JOB, CREATE ANY PROCEDURE, CREATE SESSION, CREATE ANY TABLE to ungtien_promotion;
Views: 0 thuand03cntt
How to Change Schema of an Object in SQL Server Database-SQL Server / T-SQL Tutorial Part 28
 
08:12
SQL Server / TSQL Tutorial How to Change Schema of an Object(Table,View,Stored Procedure) in SQL Server Database Link for script used in the video http://www.techbrothersit.com/2016/02/how-to-change-schema-of.html Scenario: You are working as SQL Server developer in Life Insurance Company. They have Database Name TechBrothersIT and one of the Schema name the objects are using is TB. They have given you assignment to Rename the Schema to LIFE.How would you do that? Solution: There is no straight forward way to rename a schema in SQL Server Database. We have to follow below steps to make this change. Step 1: Create a New Schema Step 2: Transfer the Objects to New Schema. Check out our website for Different SQL Server, MSBI tutorials and interview questions such as SQL Server Reporting Services(SSRS) Tutorial SQL Server Integration Services(SSIS) Tutorial SQL Server DBA Tutorial SQL Server / TSQL Tutorial ( Beginner to Advance) http://www.techbrothersit.com/
Views: 8299 TechBrothersIT
How to Create Oracle Database EASILY STEP BY STEP (Manually)!!!!!
 
21:49
The Procedure will be same if you are using 11g. Stay Tuned for More Oracle Dba Videos.
Views: 4737 shoaib shams
Part-2 | How to import sql database for Java Project using oracle 11g
 
05:57
Hey guys, In this tutorial we learn about how to import database of a given Java Project.This is done after installing a SQL Server ,here in my case I have installed Oracle 11g Server.So we use SQL Command Line to create the User.You can use any Oracle Server for SQL. It is the second part after importing the Java Project in eclipse.The link of that video is given below- https://youtu.be/pmCItJaRsmE This is Abhishek Saxena.This channel is about to solve problem which we faces generally in our daily life.Some times it take a long time to solve it.But we provide a easy solution for these problem.If you like then support us by share and subscribe our channel also press the Bell icon.Thank you for your support.
Views: 113 saxena4you
Allow remote connections to SQL Server Express : How to Video
 
07:36
Enable remote connection on SQL Server 2014 express. By default, when SQL Server Express is installed it generates a random port to listen on. In this video you will learn how to configure SQL Server 2014 Express to accept remote connections over TCP/IP using SQL Server Configuration Manager and how to open the port on firewall for incoming connection.
Views: 247499 Sachin Samy
Controlling Data Access Using Firebase Auth Custom Claims (Firecasts)
 
13:12
The Firebase Admin SDK supports defining custom attributes on user accounts. This provides the ability to implement various access control strategies, including role-based access control, in Firebase apps. These custom attributes can give users different levels of access (roles), which are enforced in an application's security rules. In this episode of Firecasts, Jen Person gives us an overview of custom auth claims, how they are useful, and what you can do with them! If you want to create a custom user experience for different kinds of users, then follow along in this episode of Firecasts! Links: Guide - Getting Started with the Admin SDK → http://bit.ly/2QMrIji Guide - Overview of Firebase Auth Admin → http://bit.ly/2O4dT14 Guide - Firebase Admin Auth Custom Claims → http://bit.ly/2OBb9Fr Firebase Auth Admin SDK Codelab → http://bit.ly/2Dkfvjr Guide - Understand Realtime Database Rules → http://bit.ly/2MRUIUA Guide - Secure Data in Cloud Firestore → http://bit.ly/2Qqrpuj Guide - Understand Security Rules for Cloud Storage → http://bit.ly/2MSa22w Firecasts Playlist → https://goo.gl/Ud2b5L To keep up with the latest from Firebase, Subscribe! → https://goo.gl/9giPHG
Views: 15879 Firebase
Oracle - SQL PLUS - Delete Data From Database
 
03:28
Previous video link how to insert record in database table... https://youtu.be/liBFLYzbteE www.facebook.com/cipherlibrary.net
Views: 177 Cipher Library
SQL Server Linked Servers
 
09:16
Learn more about Logical Read: http://bit.ly/logicalread2 SQL Server’s Linked Servers allow you to seamlessly integrate SQL Server applications with the tables, indexes and views stored in an Oracle database. Watch this video to understand the requirements and configuration for setting up a SQL Server 2014 linked server to Oracle 12c. Connect with SolarWinds: thwack Community: http://thwack.solarwinds.com/ Facebook: https://www.facebook.com/SolarWinds Twitter: https://twitter.com/solarwinds Google+: https://plus.google.com/+solarwinds/ LinkedIn: http://www.linkedin.com/company/solarwinds Instagram: http://instagram.com/solarwindsinc/ Vine: https://vine.co/SolarWinds Flickr: http://www.flickr.com/photos/solarwinds_inc/
Views: 8349 solarwindsinc
SQL, copy table from  one user to another user, lesson 13
 
05:39
How to copy a table from one user to another user or from one database to another database in oracle
Views: 9061 hammadshams