Home
Search results “Index grant oracle”
Oracle Indexes - Beginner
 
12:12
Oracle Indexes - Beginner
Views: 65698 Chris Ostrowski
Oracle - grant and revoke
 
05:28
Oracle - grant and revoke
Views: 7619 Chris Ostrowski
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: 28076 Manish Sharma
Descarga-Instalación ORACLE Express 11g, SQLdeveloper  ||  CREAR TABLESPACE -DATAFILE- USER -PASS.
 
09:03
ORACLE :http://www.oracle.com/technetwork/database/database-technologies/express-edition/downloads/index.html SQL Developer: http://www.oracle.com/technetwork/developer-tools/sql-developer/overview/index.html CODIGO EN SQL DEVELOPER --CREAR TABLESPACE CREATE TABLESPACE "TSTABLA" DATAFILE 'C:\oraclexe\app\oracle\oradata\XE\PRUEBITA.DBF' SIZE 200M; --TABLESPACE TEMPORAL CREATE TEMPORARY TABLESPACE "TSTABLA_TEMP" TEMPFILE 'C:\oraclexe\app\oracle\oradata\XE\PRUEBITA_TEMP.DBF' SIZE 200M; --DBA CREATE ROLE ADMINISTRADOR_BD; --Dar Permisos a rol GRANT CREATE SESSION TO ADMINISTRADOR_BD; GRANT CREATE ANY TABLE TO ADMINISTRADOR_BD; GRANT CREATE ROLE TO ADMINISTRADOR_BD; GRANT CREATE USER TO ADMINISTRADOR_BD; GRANT CREATE VIEW TO ADMINISTRADOR_BD; GRANT CREATE ANY INDEX TO ADMINISTRADOR_BD; GRANT CREATE TRIGGER TO ADMINISTRADOR_BD; GRANT CREATE PROCEDURE TO ADMINISTRADOR_BD; GRANT CREATE SEQUENCE TO ADMINISTRADOR_BD; --CREAR USUARIO CREATE USER USER_BD IDENTIFIED BY PASSWORD_BD DEFAULT TABLESPACE TSTABLA TEMPORARY TABLESPACE TSTABLA_TEMP; --DAR PERMISOS AL USUARIO ADMINISTRADOR_BD SOBRE TABLESPACES GRANT UNLIMITED TABLESPACE TO USER_BD; --VOLCAR ADMINISTRADOR_BD A COLECCIONES GRANT ADMINISTRADOR_BD TO USER_BD; ASTUDILLO SÁNCHEZ DANTEE MAURICIO 4-2
Views: 336 Dantee Astudillo
Oracle - Roles
 
15:01
Oracle - Roles
Views: 2448 Chris Ostrowski
Create User and Connecting With SQLPLUS in Oracle SQL Developer Using Command Prompt
 
06:08
Facebook : https://www.facebook.com/ala.hassine.10 Email : [email protected] Page Facebook Système Embarqué : https://www.facebook.com/NewEmbeddedSystem ============================= ============================= The commands used in the video : sqlplus / as sysdba CREATE USER Name IDENTIFIED BY password; GRANT ALL PRIVILEGES TO Name; GRANT EXECUTE ANY PROCEDURE TO Name; GRANT UNLIMITED TABLESPACE TO Name; GRANT CREATE SESSION TO Name; CREATE ROLE role_Name; GRANT CREATE ANY TABLE, ALTER ANY TABLE, DROP ANY TABLE TO role_Name; GRANT SELECT ANY TABLE, INSERT ANY TABLE, UPDATE ANY TABLE, DELETE ANY TABLE TO role_Name; GRANT CREATE ANY TRIGGER, ALTER ANY TRIGGER, DROP ANY TRIGGER TO role_Name; GRANT CREATE ANY SEQUENCE, ALTER ANY SEQUENCE, DROP ANY SEQUENCE TO role_Name; GRANT SELECT ANY SEQUENCE TO role_Name; GRANT CREATE ANY INDEX, ALTER ANY INDEX, DROP ANY INDEX TO role_Name; GRANT CREATE ANY PROCEDURE TO role_Name; GRANT role_Name TO Name; exit sqlplus / as sysdba exit sqlplus Name/Password ============================= ============================= CREATE TABLE employee ( empno number PRIMARY KEY, empname varchar2(70) UNIQUE, address varchar2(70), salary number NOT NULL ) ============================= insert into employee values(1,'Ala','Nabeul',1500); insert into employee values(2,'Ahmed','Tunis',2000); insert into employee values(3,'Ritej','Sfax',1700); insert into employee values(4,'Majdi','Sousse',3000); insert into employee values(5,'Raed','Bizert',2500); insert into employee values(6,'Yasser','Mahdia',1900); ============================= select * from employee;
Views: 48 Système EmbarQué
Oracle - Synonyms
 
10:43
Oracle - Synonyms
Views: 8416 Chris Ostrowski
Oracle how to create user and grant all privilege
 
13:04
Oracle how to create user and grant all privilege
Views: 257 Ly Kimchrea
23. Grant, Revoke and Grant Table View to other user in Oracle
 
09:44
In this video you will learn many things in simple and easy way. Create User, Create Role, Grant Permission on Role, Pass role to user, Pass table to other user, Grant Table permissions to other user for table access etc are the points you will learn here. For Support =========== Email: [email protected] Contact Form: http://www.learninhindi.com/home/contact Our Social Media ================ Facebook: https://www.facebook.com/LearnInHindi Twitter: https://twitter.com/LearnInHindi For Training & Videos ===================== For more videos and articles visit: http://www.learninhindi.com Free Java Programming In Hindi Course ===================================== https://www.youtube.com/playlist?list=PLOZ3jentlCDAwwhMyoLISrxkXTADGp7PH Free Oracle PL/SQL Programming In Hindi Course ============================================== https://www.youtube.com/playlist?list=PLB5DA82419C2D99B6 Free C Programming In Hindi Course ================================== https://www.youtube.com/playlist?list=PLOZ3jentlCDAxKpBLMWogxSdy6BZcsAJq Trips & Tricks Channel ====================== https://www.youtube.com/channel/UCGmLfkuCo-3lHHJXRJ9HUMw Programming in Hindi Channel ============================ https://www.youtube.com/channel/UCudElIDgwNrybeAvXIy1HZQ
Views: 40113 ITORIAN
Oracle Indexes Lesson 2 What and Why
 
10:14
What is an Oracle B-Tree Index? Why do we create them? Learn the answers here. See all lessons, FREE, at http://www.skillbuilders.com/all-about-oracle-btree-indexes.
Views: 448 SkillBuilders
Oracle - Managing Views, Sequences, Synonyms, and Index
 
03:18
Oracle - Managing Views, Sequences, Synonyms, and Index
Views: 250 Si Ruy
oracle tutorial for sequence, index,synonim
 
06:46
oracle tutorial for sequence, index,synonim
Views: 80 magan lal
Tutorial 42 : INDEX in Oracle || B TREE INDEX.
 
05:21
Hi Friends! Here we are learning about B TREE INDEX. Hope the concept is clear to you. For any confusion or doubt let me know in comment box. Thanks. Happy Coding.
Views: 140 YourSmartCode
Oracle SEQUENCES - Beginner
 
12:50
Oracle SEQUENCES - Beginner
Views: 12049 Chris Ostrowski
Creating an Index in Oracle SQL
 
03:36
This video shows how to Create an index in Oracle SQL . Try to share these videos for poor students and subscribe this channel for more upcoming other technical videos.
Views: 28 Technology mart
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 SYNONYMS - beginner
 
09:21
Oracle SYNONYMS - beginner
Views: 7896 Chris Ostrowski
Oracle DB - Privilege
 
11:50
Oracle DB - Privilege Watch More Videos at: https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Parth Panjabi, Tutorials Point India Private Limited
Instalación Oracle Express 11g & SQLdeveloper  **Creación de TABLESPACE, DATAFILE, USER**
 
10:06
Holaaa! Muchas gracias por ver el vídeo, no olvides dejar tu like si te ha gustado y suscribete si te gusta mi contenido :) ME PUEDES ENCONTRAR EN➨ 🔥 INSTAGRAM https://www.instagram.com/charliesannz/ Oracle Database Express Edition 11: http://www.oracle.com/technetwork/database/database-technologies/express-edition/downloads/index.html Oracle sql-develope: http://www.oracle.com/technetwork/developer-tools/sql-developer/overview/index.html ---CODIGO EN SQL DEVELOPER--- --CREAR TABLESPACE CREATE TABLESPACE "BASEDATOSTABLA" DATAFILE 'C:\oraclexe\app\oracle\Pruebafinal.DBF' SIZE 200M; --TABLESPACE TEMPORAL CREATE TEMPORARY TABLESPACE "BASEDATOSTABLA" TEMPFILE 'C:\oraclexe\app\oracle\Pruebafinal_TEMP.DBF' SIZE 200M; --DBA CREATE ROLE ADMI; --Dar Permisos a los DBD GRANT CREATE SESSION TO ADMI; GRANT CREATE ANY TABLE TO ADMI; GRANT CREATE ROLE TO ADMI; GRANT CREATE USER TO ADMI; GRANT CREATE VIEW TO ADMI; GRANT CREATE ANY INDEX TO ADMI; GRANT CREATE TRIGGER TO ADMI; GRANT CREATE PROCEDURE TO ADMI; GRANT CREATE SEQUENCE TO ADMI; --CREAR USUARIO CREATE USER NOM_USUA IDENTIFIED BY CONTRA_USUA DEFAULT TABLESPACE BASEDATOSTABLA TEMPORARY TABLESPACE BASEDATOSTABLA_TEMP; --DAR PERMISOS AL USUARIO "ADMI" SOBRE TABLESPACES GRANT UNLIMITED TABLESPACE TO NUEVOUSUARIO_BD; --INVERTIR "ADMI" A COLECCIONES GRANT ADMI TO NUEVOUSUARIO_BD;
Views: 166 Sanz
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: 23693 Manish Sharma
Why Won't Oracle Use My Index - 12c Attribute Clustering - Lesson 1
 
01:46
Sometimes a poor clustering factor is the cause when Oracle Database cost based optimizer does not choose to use an index. With Oracle 12c (12.1.0.2 EE) offers a new feature that can really help - "Atrribute Clustering". This is implemented with a new keyword on CREATE TABLE - "CLUSTERING BY LINEAR ORDER". In this Free Tutorial from SkillBuilders and Oracle Certified Master DBA John Watson, you'll get a brief refresher on clustering factor and a demonstration of CREATE TABLE - "CLUSTERING BY LINEAR ORDER" - so the CBO will use your index! In this first lesson, John will provide a brief review of clustering factor. See all 6 lessons - FREE - at http://www.skillbuilders.com/12c-attribute-clustering
Views: 376 SkillBuilders
Oracle 12c Grant Role to PL/SQL Procedures - Lesson 1 of 2
 
03:35
A great new security feature that can - among other things - prevent SQL injection and a multitude of other security vulnerabilities. In 12c you can make your PL/SQL code secure using a declarative technique. Simply grant a role to the PL/SQL code and add AUTHID CURRENT_USER so that Oracle runs the code with the privileges of the invoker - not the developer (invoker rights procedures). Presto! Without code reviews and / or debugging you will have hardened your PL/SQL web application! In this free tutorial from SkillBuilders Director of Oracle Database Services, Oracle Certified Master John Watson will demonstrate the development of a simple PL/SQL web application, demonstrate SQL injection and how to prevent it with this new feature.
Views: 698 SkillBuilders
Oracle Reports Builder Tutorials (8 of 40)
 
18:19
Oracle Fusion Middleware Oracle Reports Tutorial How to: Create a Master-Detail Report Keywords: barcode in oracle reports best reporting tool for oracle database building reports convert oracle forms to java database report builder db2 sql download oracle download oracle developer download oracle forms 6i download oracle report builder 10g download oracle weblogic server 11g form 6 form builder oracle form report functions in oracle how to create oracle forms how to develop oracle forms how to generate report in oracle jdbc oracle microsoft t sql migrate oracle forms odbc driver for oracle oracel bi oracle 10g oracle 11 oracle 11i oracle 9i download oracle analytics oracle application server oracle applications oracle apps oracle bi oracle bi 11g oracle bi 12c oracle bi administration tool oracle bi analytics oracle bi applications oracle bi apps oracle bi architecture oracle bi cloud oracle bi consultant oracle bi dashboard tutorial oracle bi discoverer oracle bi ee oracle bi foundation suite oracle bi hd oracle bi intelligence oracle bi mobile app oracle bi online training oracle bi platform oracle bi products oracle bi publisher download oracle bi publisher enterprise oracle bi publisher reports oracle bi reporting oracle bi security oracle bi server oracle bi solutions oracle bi tools oracle bi training online oracle bi versions oracle biee oracle business analytics oracle business intelligence 11g developers guide free pdf oracle business intelligence applications oracle business intelligence architecture diagram oracle business intelligence certification path oracle business intelligence download oracle business intelligence enterprise edition 11g oracle business intelligence enterprise edition obiee oracle business intelligence foundation suite oracle business intelligence obiee oracle business intelligence salary oracle business intelligence software oracle business intelligence suite enterprise edition oracle business intelligence training oracle business intelligence tutorial oracle business intelligence wiki oracle by example oracle certification oracle crm oracle dashboard oracle data types oracle database oracle database 11g oracle database application oracle database developer job description oracle database developer jobs oracle database download oracle database logs oracle database management oracle database manager oracle database monitoring oracle database performance oracle database products oracle database reporting tools oracle database software oracle database support oracle database tools oracle database training oracle database tuning oracle database tutorial oracle date oracle dba oracle dba jobs oracle dba resume oracle dba scripts oracle dba training oracle dba tutorial oracle designer oracle developer oracle developer download oracle developer jobs oracle developer salary oracle developer tools oracle developer training oracle discoverer oracle documentation oracle dump oracle enterprise manager oracle erp oracle financial analytics oracle financials oracle for business oracle for linux oracle form builder oracle form builder 10g download oracle forms oracle forms 10g oracle forms 6i oracle forms and reports 6i software free download oracle forms and reports books oracle forms and reports tutorial oracle forms and reports tutorial for beginners pdf oracle forms developer guide oracle forms developer guide 10g oracle forms development oracle forms migration oracle forms migration from 6i to 11g oracle forms training oracle forms tutorial oracle foundation suite oracle free download oracle grant oracle hyperion bi oracle ias oracle in oracle index oracle jdbc oracle jdbc driver oracle jobs oracle linux oracle linux install oracle obi oracle obie oracle obiee oracle obiee architecture oracle obiee download oracle odbc oracle odbc driver oracle otn oracle portal oracle programmer oracle purchasing reports oracle queries oracle rdbms oracle replication oracle report oracle report builder oracle report builder 11g download oracle report builder 6i download oracle report com oracle report tutorial oracle reporting tool oracle reporting tool obiee oracle reporting tools oracle reporting tools free oracle reports 12c oracle reports tutorial oracle reports tutorial for beginners oracle schema oracle script oracle sequence oracle shop oracle software oracle sql books oracle sql commands oracle system oracle transactional business intelligence oracle tutorial oracle university oracle utilities oracle utilities business intelligence orcale bi report report builder report builder download report builder tutorial report designer download report developer report form report oracle tutorial reportbuilder reporting tools for oracle sql form builder sql report builder the oracle report tuning oracle database what is business intelligence what is obiee what is obiee in oracle what is oracle what is oracle business intelligence what is oracle obiee why business intelligence
Views: 4676 Muhammad Abid
When to use Oracle Database Bitmap Indexes Lesson 2
 
13:40
This lesson demonstrates cases where a *B-Tree* index cannot be used AND shows how Oracle will use a *bitmap* index. See all lessons, free, at http://www.skillbuilders.com/when-to-use-oracle-bitmap-indexes.
Views: 742 SkillBuilders
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: 64906 Manish Sharma
Oracle - SQL - Insert Statement
 
09:30
Oracle - SQL - Insert Statement Watch more Videos at https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Anadi Sharma, Tutorials Point India Private Limited.
How To Create Oracle Database - Using GUI - Browser
 
05:29
Use oracle database in GUI. Connect, Create Workspace and User Oracle Database Express Edition 11g Release 2 download link http://www.oracle.com/technetwork/database/database-technologies/express-edition/downloads/index.html
Views: 7006 Tech Tips
Oracle DB 12c - Privileges
 
15:40
Oracle DB 12c - Privileges Watch more videos at https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Parth Panjabi, Tutorials Point India Private Limited
Instalación de Oracle Database 11g Express Edition - Creación de Datafile y Namespace
 
10:36
Links de Descarga: Oracle Database: http://www.oracle.com/technetwork/database/database-technologies/express-edition/overview/index.html Oracle SQL Developer: http://www.oracle.com/technetwork/developer-tools/sql-developer/overview/index.html EJEMPLO CÓDIGO (SQL DEVELOPER): --CREAR TABLESPACE CREATE TABLESPACE "TSTABLA" DATAFILE 'C:\oraclexe\app\oracle\oradata\XE\PRUEBITA.DBF' SIZE 200M; --TABLESPACE TEMPORAL CREATE TEMPORARY TABLESPACE "TSTABLA_TEMP" TEMPFILE 'C:\oraclexe\app\oracle\oradata\XE\PRUEBITA_TEMP.DBF' SIZE 200M; --DBA CREATE ROLE ADMINISTRADOR_BD; --Dar Permisos a rol GRANT CREATE SESSION TO ADMINISTRADOR_BD; GRANT CREATE ANY TABLE TO ADMINISTRADOR_BD; GRANT CREATE ROLE TO ADMINISTRADOR_BD; GRANT CREATE USER TO ADMINISTRADOR_BD; GRANT CREATE VIEW TO ADMINISTRADOR_BD; GRANT CREATE ANY INDEX TO ADMINISTRADOR_BD; GRANT CREATE TRIGGER TO ADMINISTRADOR_BD; GRANT CREATE PROCEDURE TO ADMINISTRADOR_BD; GRANT CREATE SEQUENCE TO ADMINISTRADOR_BD; --CREAR USUARIO CREATE USER USER_BD IDENTIFIED BY PASSWORD_BD DEFAULT TABLESPACE TSTABLA TEMPORARY TABLESPACE TSTABLA_TEMP; --DAR PERMISOS AL USUARIO ADMINISTRADOR_BD SOBRE TABLESPACES GRANT UNLIMITED TABLESPACE TO USER_BD; --VOLCAR ADMINISTRADOR_BD A COLECCIONES GRANT ADMINISTRADOR_BD TO USER_BD;
Views: 14 Gabriel Cordero
Difference between an Oracle user and schema - Database Tutorial 59 - Oracle DBA Tutorial
 
04:45
Difference between an Oracle user and schema - Database Tutorial 59 - Oracle DBA Tutorial An Oracle user is an account that is owned by an employee. These user accounts are not expected to create any objects. However they will be given access to objects owned by the schemas. A schema is a generic user. But it will own objects that are used by the other users and the applications.
Views: 5619 Sam Dhanasekaran
Oracle Express - SQL Developer (DataFile, TableSpace, User)
 
08:55
Codigo: --CREAR TABLESPACE CREATE TABLESPACE "TSTABLA" DATAFILE 'C:\oraclexe\app\oracle\oradata\XE\PRUEBITA.DBF' SIZE 200M; --TABLESPACE TEMPORAL CREATE TEMPORARY TABLESPACE "TSTABLA_TEMP" TEMPFILE 'C:\oraclexe\app\oracle\oradata\XE\PRUEBITA_TEMP.DBF' SIZE 200M; --DBA CREATE ROLE ADMINISTRADOR_BD; --Dar Permisos a rol GRANT CREATE SESSION TO ADMINISTRADOR_BD; GRANT CREATE ANY TABLE TO ADMINISTRADOR_BD; GRANT CREATE ROLE TO ADMINISTRADOR_BD; GRANT CREATE USER TO ADMINISTRADOR_BD; GRANT CREATE VIEW TO ADMINISTRADOR_BD; GRANT CREATE ANY INDEX TO ADMINISTRADOR_BD; GRANT CREATE TRIGGER TO ADMINISTRADOR_BD; GRANT CREATE PROCEDURE TO ADMINISTRADOR_BD; GRANT CREATE SEQUENCE TO ADMINISTRADOR_BD; --CREAR USUARIO CREATE USER USER_BD IDENTIFIED BY PASSWORD_BD DEFAULT TABLESPACE TSTABLA TEMPORARY TABLESPACE TSTABLA_TEMP; --DAR PERMISOS AL USUARIO ADMINISTRADOR_BD SOBRE TABLESPACES GRANT UNLIMITED TABLESPACE TO USER_BD; --VOLCAR ADMINISTRADOR_BD A COLECCIONES GRANT ADMINISTRADOR_BD TO USER_BD;
Views: 37 Jesus Hidalgo
Oracle - SQL - Update Statement
 
03:45
Oracle - SQL - Update Statement Watch more Videos at https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Anadi Sharma, Tutorials Point India Private Limited.
What permissions will you grant to a users in SQL Server database, so He or She can truncate table
 
06:00
SQL Server Interview Question "What permissions will you grant to a users in SQL Server database, so He/She can truncate table?" Complete list of SQL Server DBA Interview Questions by Tech Brothers http://sqlage.blogspot.com/search/label/SQL%20SERVER%20DBA%20INTERVIEW%20QUESTIONS
Views: 15644 TechBrothersIT
Synonyms in Oracle Database
 
10:29
advantages of synonyms in oracle, how to find public synonyms in oracle, types of synonyms in oracle, oracle synonym table, create synonym oracle 11g, public and private synonyms in oracle, drop synonym oracle
Views: 65 Adam Tech
SQL tutorial 74: SQL COALESCE Function In oracle Database Manish Sharma
 
04:44
Third tutorial in SQL Null Series. Coalesce Null function with example in oracle Database. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/sql-coalesce Previous Tutorial ► NVL https://youtu.be/aRoTR5Jn6K0 ► NVL2 https://youtu.be/SCwc0HcS1-U ------------------------------------------------------------------------- ►►►Let's Get Free Uber Cab◄◄◄ Use Referral Code UberRebellionRider and get $20 free for your first ride. ------------------------------------------------------------------------- ►►►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 -------------------------------------------------------------------------- ►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 for E-mail address please check About section 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: 27046 Manish Sharma
Oracle 12c PL/SQL Security Features - Lesson 4 of 8 - Roles and PLSQL
 
06:21
Learn how Roles really work with Oracle PL/SQL and why a privilege granted via a role can't be used in PL/SQL. Demonstrations, examples. See all lessons and many more free Oracle Database tutorials at https://www.skillbuilders.com/free-oracle-database-tutorials John Watson: We have the business of roles - roles and PL/SQL. The point here is that roles are invisible to PL/SQL. When you compile your code, only direct privileges are available. When you run your code, only direct privileges are available. This is for definer's rights, I should say. When you run the code, only direct privileges are available to grant to the definer. In effect, the definer's rights code, all roles are disabled within the stored procedure. And certainly roles are disabled when compiling the code. Functionally, it's equivalent to having issued the command SET ROLE NONE. Why is this? Why is it you can't use your privileges? It's perfectly straightforward. It's a technology limitation. Quickly to see what's going on. If I go in and say - let me connect or create a clear schema. I'll create myself, grant dba to jw identified by jw. I've created a user and given him ridiculously high privileges. Connect.... What can you do? You can do pretty much anything. If he wants to delete from scott.emp, he can do it. Let's roll back, because along with his dba role, he has the ability to pretty much anything to use the data. Now we'll create a procedure. If I create a procedure, create delemp as begin, and in there I delete from scott.emp, end, compilation errors. What are they? Show error. At line 2 table of view doesn't exist. That's line 2 delete from scott.emp. I remember way back in version 7, this cause so much confusion before we realized what was going on. It's quite simple that when we are within the code, as the definer or the invoker, because this is definer's rights code, when we are within the definer's rights code block or indeed when we are compiling a definer's rights code block, the roles are disabled and that's why we cannot see it. But why is this and why do I say it's a technology limitation? It's because roles can be enabled and disabled. They can be enabled or disabled. That makes it logically impossible to consider a role when executing a stored procedure because I might have the role enabled while I compile it, but how do I know that it's going to be enabled when I run it? If I grant execute on the code to a third party, he doesn't have the role at all and that he must not even be logged on. So it becomes a logical impossibility because of the way roles are used because roles are enabled or disabled. You can dynamically switch them on and off. It's a logical impossibility to use role within definer's rights program module. Invoker's rights code, however, is very different. That infuses some interesting issues. Invoker's rights code can use any roles that happen to be enabled for the user at the time that he invokes it in exactly the same way that an anonymous PL/SQL can use any enabled roles. In the security point of view, the definer can in effect grab any roles within his code that the invoker happens to have. Dave: [Question], John, pardon. How do you enable or disable a role? John: Right now there's several techniques. I won't spend too much time demonstrating. The easiest technique will be alter - I can set role none. And that will have disabled all my roles. Now if you look at this, I've got nothing. If I try to run my code and query - let's see. Yes. If I try to delete from scott.emp I can't see it. So I'll set role dba and now of course I can. That's the easiest way. In fact, there are much more [05:07 inaudible] ways to switch roles on and off. We can do it with operating system authentication and I can do it with proxy authentication. We have a persistent session through application server as well as a user when we pass that session out to many of the users that can switch roles on and off. That's the persistent session switch identities. Perhaps, best of all, I can create what I call secure application roles well it protect the role with a package and that can contest any number of issues - environment variables, maybe the time, maybe your IP address, perhaps the program you're using and switch roles on and off accordingly. So there are many ways for controlling roles and you should do it. Blindly granting roles and letting them be enabled all the time is not good security. The end result for this, however, you can get some pretty unexpected results within your code. I've tried to run through in our first half hour some of the issues that we see with PL/SQL in release 11g and earlier. After a short break, we'll move on to the 12c features.
Views: 285 SkillBuilders
Database,SQL And Oracle Day4
 
02:56:05
Create user and grant and revoke ,oracle functions
Views: 210 Cloud9 Creations
45. Primary Key and Foreign Key Constraints in PL/SQL Oracle
 
12:36
In this video you will learn about Primary Key and Foreign Key Constraints in PL/SQL Oracle. For Support =========== Email: [email protected] Contact Form: http://www.learninhindi.com/home/contact Our Social Media ================ Facebook: https://www.facebook.com/LearnInHindi Twitter: https://twitter.com/LearnInHindi For Training & Videos ===================== For more videos and articles visit: http://www.learninhindi.com Free Java Programming In Hindi Course ===================================== https://www.youtube.com/playlist?list=PLOZ3jentlCDAwwhMyoLISrxkXTADGp7PH Free Oracle PL/SQL Programming In Hindi Course ============================================== https://www.youtube.com/playlist?list=PLB5DA82419C2D99B6 Free C Programming In Hindi Course ================================== https://www.youtube.com/playlist?list=PLOZ3jentlCDAxKpBLMWogxSdy6BZcsAJq Trips & Tricks Channel ====================== https://www.youtube.com/channel/UCGmLfkuCo-3lHHJXRJ9HUMw Programming in Hindi Channel ============================ https://www.youtube.com/channel/UCudElIDgwNrybeAvXIy1HZQ
Views: 10866 ITORIAN
Instalacion ORACLE express, Creacion de TableSpace, DataFile y Usuario
 
08:49
Link de Oracle: http://www.oracle.com/technetwork/database/database-technologies/express-edition/downloads/index.html Link SqlDeveloper: http://www.oracle.com/technetwork/developer-tools/sql-developer/overview/index.html CODIGO UTILIZADO EN SQL DEVELOPER: --CREAR TABLESPACE CREATE TABLESPACE "TSTABLA" DATAFILE 'C:\oraclexe\app\oracle\oradata\XE\Tutorial.DBF' SIZE 200M; --TABLESPACE TEMPORAL CREATE TEMPORARY TABLESPACE "TSTABLA_TEMP" TEMPFILE 'C:\oraclexe\app\oracle\oradata\XE\Tutorial_TEMP.DBF' SIZE 200M; --DBA CREATE ROLE ADMINISTRADOR_BD; --Dar Permisos a rol GRANT CREATE SESSION TO ADMINISTRADOR_BD; GRANT CREATE ANY TABLE TO ADMINISTRADOR_BD; GRANT CREATE ROLE TO ADMINISTRADOR_BD; GRANT CREATE USER TO ADMINISTRADOR_BD; GRANT CREATE VIEW TO ADMINISTRADOR_BD; GRANT CREATE ANY INDEX TO ADMINISTRADOR_BD; GRANT CREATE TRIGGER TO ADMINISTRADOR_BD; GRANT CREATE PROCEDURE TO ADMINISTRADOR_BD; GRANT CREATE SEQUENCE TO ADMINISTRADOR_BD; --CREAR USUARIO CREATE USER USER_BD IDENTIFIED BY PASSWORD_BD DEFAULT TABLESPACE TSTABLA TEMPORARY TABLESPACE TSTABLA_TEMP; --DAR PERMISOS AL USUARIO ADMINISTRADOR_BD SOBRE TABLESPACES GRANT UNLIMITED TABLESPACE TO USER_BD; --VOLCAR ADMINISTRADOR_BD A COLECCIONES GRANT ADMINISTRADOR_BD TO USER_BD; VIDEO HECHO POR Darlin Gutiérrez Freire Curso: 4-3
Views: 72 Darlin Gutierrez
Comparing Temporary Tables in Oracle and SQL Server
 
01:11:08
Presented by Jonathan Lewis (Oracle ACE Director, OakTable) and Grant Fritchey (SQL Server MVP) Thurs 11th October 2012 Summary Temporary tables are often used in applications for processes that are difficult to complete in a single pass. They are widely used in SQL Server development and can be local and global. In Oracle temporary tables are created with a static global definition, but are used to hold temporary local content. But is this the only difference in temporary tables in Oracle and SQL Server? What about the performance impacts/gains for using temporary tables, and does this differ in Oracle and SQL Server? Once again Jonathan Lewis (Oracle Ace Director, OakTable Network) and Grant Fritchey (Microsoft SQL Server MVP) will host a live discussion on Oracle and SQL Server, this time in relation to temporary tables. Will they agree on some common ground? Or will it be an out and out argument? Either way, be prepared for a lively exchange that will not only entertain, but will teach you key concepts on Oracle and SQL Server. A Q+A session with Jonathan and Grant will follow the presentation. For our complete archive, and to sign up for upcoming webinars please go to http://www.red-gate.com/oracle-webinars
Views: 2714 Redgate Videos
Oracle Reports Builder Tutorials (7 of 40)
 
13:32
Oracle Report Builder/Developer Tutorial In this free online IT video tutorials & training , you will learn about single query group above/left reports. Oracle Reports is a tool for developing reports against data stored in an Oracle database. Oracle Reports consists of Oracle Reports Developer (a component of the Oracle Developer Suite) and Oracle Application Server Reports Services (a component of the Oracle Application Server). Keyword: best reporting tool for oracle database convert oracle forms to java db2 sql download oracle download oracle developer download oracle report builder 10g form report functions in oracle how to generate report in oracle jdbc oracle microsoft t sql migrate oracle forms odbc driver for oracle oracle 10g oracle 11i oracle 9i download oracle application server oracle applications oracle apps oracle by example oracle certification oracle dashboard oracle data types oracle database oracle database 11g oracle database application oracle database download oracle database logs oracle database management oracle database manager oracle database monitoring oracle database performance oracle database products oracle database reporting tools oracle database software oracle database support oracle database tools oracle database training oracle database tuning oracle database tutorial oracle date oracle dba oracle dba jobs oracle dba resume oracle dba scripts oracle dba training oracle dba tutorial oracle designer oracle developer oracle developer download oracle developer jobs oracle developer training oracle discoverer oracle documentation oracle dump oracle enterprise manager oracle erp oracle financials oracle for linux oracle forms oracle forms 10g oracle forms 6i oracle forms development oracle forms migration oracle forms training oracle forms tutorial oracle grant oracle ias oracle in oracle index oracle jdbc oracle jdbc driver oracle jobs oracle linux oracle odbc oracle odbc driver oracle otn oracle portal oracle purchasing reports oracle queries oracle rdbms oracle replication oracle report oracle report builder oracle report builder 11g download oracle report com oracle report tutorial oracle reporting tool oracle reporting tools oracle reports 12c oracle reports tutorial oracle reports tutorial for beginners oracle schema oracle script oracle sequence oracle shop oracle software oracle sql books oracle sql commands oracle system oracle tutorial oracle university oracle utilities report report oracle tutorial reporting tools for oracle the oracle report tuning oracle database what is oracle
Views: 4821 Muhammad Abid
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
Views in the Oracle Database
 
13:56
Views in the Oracle Database
Views: 8107 Chris Ostrowski
Enterprise JavaScript - Oracle JET
 
10:14
Geertjan Wielenga gives a demo of the Oracle JavaScript Extension Toolkit. He shows how to use GeoMap and Json with JET to create a customize map. Learn more about Oracle JET at http://www.oracle.com/webfolder/technetwork/jet/index.html Resources: http://www.oracle.com/technetwork/developer-tools/jet/overview/index.html
Views: 3404 Java
1Z0-052 How to create tablespace in Oracle database 11g
 
03:56
A tablespace is a logical storage unit in an Oracle database. It is called logical because a tablespace is not visible in the file system of the machine where the database resides. Each table, index, and file stored in an Oracle database belongs to the tablespace itself. A tablespace acts like a bridge between the Oracle database system and the filesystem in which the table's or index's data is stored. There are three types of tablespaces: Permanent tablespaces, Undo tablespaces and Temporary tablespaces.
Views: 9369 Surabhi Verma