Home
Search results “Grant privileges sequence oracle”
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: 25133 Manish Sharma
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: 23378 jbleistein11
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: 13057 Oracle World
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: 29993 Manish Sharma
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: 26277 Manish Sharma
APEX01.SQL01: SQL commands to create a user (schema) and grant roles and privileges
 
04:50
This video explains the SQL used in the APEX 01 video. It shows a set of SQL commands are used to create a schema (account) in Oracle XE. A brief explanation of the commands is given. Scripts for the videos are at: http://db.kreie.net
Views: 1708 Jennifer Kreie
Controlling User Access In Oracle
 
30:12
The mechanism of controlling user's access in Oracle. http://mentorsnet.org/course_preview?course_id=4
Views: 4400 Oresoft LWC
Oracle DBA Justin - How to revoke a system privilege from a user in an Oracle database
 
06:29
How to revoke a system privilege from a user in an Oracle database
Views: 2294 jbleistein11
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 DBA Justin - How to reset the log sequence number in an Oracle database
 
10:39
How to reset the log sequence number in an Oracle database
Views: 5307 jbleistein11
Exercise 6   Creating sequences and inserting the record into Database using Sequences
 
11:06
In this tutorial, i am going to explain how to create the sequence and to use the sequence to insert the record into the database table.
Views: 304 Arun krishnamoorthy
Oracle DBA Justin - How to lock and unlock a user account in an Oracle database
 
02:43
How to lock and unlock a user account in an Oracle database
Views: 18690 jbleistein11
Oracle DCL Commands and TCL Commands
 
15:53
DURGASOFT is INDIA's No.1 Software Training Center offers online training on various technologies like JAVA, .NET , ANDROID,HADOOP,TESTING TOOLS , ADF, INFORMATICA, SAP... courses from Hyderabad & Bangalore -India with Real Time Experts. Mail us your requirements to [email protected] so that our Supporting Team will arrange Demo Sessions. Ph:Call +91-8885252627,+91-7207212428,+91-7207212427,+91-8096969696. http://durgasoft.com http://durgasoftonlinetraining.com https://www.facebook.com/durgasoftware http://durgajobs.com https://www.facebook.com/durgajobsinfo......
SQL: Sequence Generator Part-2
 
05:48
In this tutorial, you'll learn how to create SG..
Views: 6933 radhikaravikumar
Oracle DBA Justin - How to create a basic VPD policy
 
14:13
How to create a basic VPD policy
Views: 6294 jbleistein11
Intermediate Oracle 11g - 7. User and Security
 
01:44:20
This Intermediate course expands on the Introduction to Oracle 11g course. It gives you a more detailed grass roots knowledge of Oracle SQL and Oracle PL/SQL. Author covers a wide range of topics including many types of queries, expressions, and statements. He also explores sequences, synonyms, views, materialized views, user access and security, working with indexes, and the basics of programming with PL/SQL. As with the introductory course, this intermediate course is not focused on Oracle Certification but will give you a good start towards some more advanced aspects of coding SQL and PL/SQL. Parts: 01. Oracle Security pt. 1 02. Oracle Security pt. 2 03. Types of Users 04. Create User Syntax pt. 1 05. Create User Syntax pt. 2 06. Using CREATE USER pt. 1 07. Using CREATE USER pt. 2 08. Alter and Drop User Syntax 09. Using ALTER and DROP USER 10. Oracle Power Users 11. Resources and Profiles 12. Privileges pt. 1 13. Privileges pt. 2 14. Granting and Revoking Privileges 15. Using GRANT pt. 1 16. Using GRANT pt. 2 17. Using REVOKE 18. Group Privileges Using Roles 19. Setting Roles 20. Metadata Views pt. 1 21. Metadata Views pt. 2
Views: 26 Free Training
SQL, Oracle Roles and Privileges, 2e56
 
06:00
Video will discuss application of roles in Oracle envirnonment and use of some important SQL statements associated with it.
Views: 1296 hammadshams
Oracle Tutorial || Oracle|Sql commands DCL Commands Part - 1 by basha
 
24:25
DURGASOFT is INDIA's No.1 Software Training Center offers online training on various technologies like JAVA, .NET , ANDROID,HADOOP,TESTING TOOLS ,ADF,INFORMATICA,TABLEAU,IPHONE,OBIEE,ANJULAR JS, SAP... courses from Hyderabad & Bangalore -India with Real Time Experts. Mail us your requirements to [email protected] so that our Supporting Team will arrange Demo Sessions. Ph:Call +91-8885252627,+91-7207212428,+91-7207212427,+91-8096969696. http://durgasoft.com http://durgasoftonlinetraining.com https://www.facebook.com/durgasoftware http://durgajobs.com https://www.facebook.com/durgajobsinfo......
Oracle - Roles
 
15:01
Oracle - Roles
Views: 2552 Chris Ostrowski
Oracle DBA Justin - How to put an Oracle database in restricted session mode
 
09:30
How to put an Oracle database in restricted session mode
Views: 2607 jbleistein11
How to Create Data Access for User in Oracle Fusion R13|Using ADFDI|Job Roles and Data Roles|RBAC|
 
16:18
How to Create Data Access for User in Oracle Fusion R13 using ADFDI|User Provisioning|Job Roles and Data Roles|RBCA| Use the Manage Data Access for Users page to assign data access to users based on their job roles. #DATAROLE,#Oraclecloud,#RBAC,#DATAACCESS,#JOBROLE,#USERPROVISIONING You can assign data access in Oracle Fusion R13 One user at a time or Group of users with similar job roles follow below process 1.Create users using Manage user in Functional Setup Manager or Security Console from Navigation Specify user attributes such as user name, assigned business unit, legal employer, department, job, position, grade, and location. 2.Assign the required job role to users. Use Oracle Fusion Human Capital Management or the Security Console to assign job roles. Assign data access using the Manage Data Access for Users task in the Functional Setup Manager. You Can assign Business units,Inventory Organization,Project Organization,Ledger,Asset Books to Users and their specific roles 3.You can upload bulk Data Access through ADFDI Template in Oracle Fusion For free access to Oracle Fusion Instance pls subscribe to this Channel and click on the bell button to get latest updates
Views: 531 MY TECHNO JOURNAL
Simplified DBA-018-User Privileges
 
13:21
A privilege is a right to execute a particular type of SQL statement or to access another user’s object. The Oracle database enables you to control what the users can and cannot do in the database. Privileges are divided into two categories: System privileges: Each system privilege allows a user to perform a particular database operation or class of database operations. For example, the privilege to create tablespaces is a system privilege. System privileges can be granted by the administrator or by someone who has been given explicit permission to administer the privilege. Object privileges: Object privileges allow a user to perform a particular action on a specific object, such as a table, view, sequence, procedure, function, or package. Without specific permission, users can access only their own objects. Object privileges can be granted by the owner of an object, by the administrator, or by someone who has been explicitly given permission to grant privileges on the object. For example, in our demo ERPUSER will own the tables and other users will require read, write object privileges on ERPUSER tables. Example Connect erpuser/welcome1 Grant insert on myable1 to user1; Grant insert on myable1 to user5 Create tablespace erp_data datafile ‘/u01/app/oradata/db11lin/erpdata01.dbf’ size 100M autoextend on; Create user erpuser identified by welcome1 default tablespace erp_data temporary tablespace temp; Grant connect, resource to erpuser; Create user user1 identified by welcome1 default tablespace erp_data temporary tablespace temp; Create table erpuser.mytable1 ( sno number(5), sname varchar2(20)); We can create a table for any user in this format if we have dba privileges. [owner.tablename] Connect user1/welcome1 Insert into erpuser.mytable1 values(100, ‘by user1’); Commit;
Synonyms in Oracle PL SQL
 
03:48
Synonyms in Oracle #techquerypond sql synonyms oracle synonym what is Synonyms in Oracle ? 1)A synonym is an alternative name tO objects. 2)Objects like tables, views, sequences, stored procedures. 3)Generally we use to granting or revoking the access. 4)It means that the synonym is a public synonym and is accessible to all users. 5)Please note user must first have the appropriate privileges to access synonym. To get more information watch the above video. For example: CREATE PUBLIC SYNONYM EMP FOR EMPLOYEE; SELECT * FROM EMP; DROP PUBLIC SYNONYM EMP; https://techquerypond.wordpress.com https://techquerypond.com https://twitter.com/techquerypond
Views: 1699 Tech Query Pond
ORACLE SQL 45: Create & Drop Sequence
 
06:37
http://studyandshare.wordpress.com/ http://www.facebook.com/groups/studyandsharevn/
Views: 2506 studyandsharevn
099- Oracle SQL 12c: Controlling User Access part 2/نظري
 
09:48
تعلم اوراكل حتى الاحتراف تعلم اوراكل من الصفر EXAM 1Z0-061 EXAM 1Z0-071
Views: 1414 khaled alkhudari
Oracle Roles and Privileges - Database Tutorial 47 - Oracle DBA Tutorial
 
07:36
Video 47 Oracle Roles and Privileges This video explains about Oracle Database Roles and Privileges
Views: 1680 Sam Dhanasekaran
SQL tutorial 37: How to create NEW USER account using Create User statement in Oracle database
 
07:39
How to create new user accounts using Oracle Create User statement Of Oracle database. In This tutorial, you will learn how to create a new user account. Brief explanation of Create user statement syntax and an example of creating a new user and You will learn How to grant Create session system privilege to your ----_Links_--- Blog: http://bit.ly/create_user_account Video Tut 4: http://youtu.be/wSqoXRlXDUU How to create a 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: 44507 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: 421 ActiveKite
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
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: 28926 Manish Sharma
7 DATABASE OBJECTS in oracle
 
17:01
Views, synonyms, indexes, sequences
Views: 2457 NewTechnology
91/125 Oracle PLSQL: Creating Triggers / Default Value
 
05:23
Creating Triggers in oracle Learn Oracle PLSQL EXAM 1Z0-144
Views: 803 khaled alkhudari
HOW TO CREATE USER IN ORACLE AND DROP IT
 
08:02
by Kumar:Oracle This video will tell you how to create user and grant him dba privilege to the created user , and how to drop it.
Views: 562 brijesh kumar
Creating roles and privleges  in Oracle 12c - Part 1
 
26:33
This tutorial is about creating roles in Oracle and assigning to user. Roles plays an important part in business architecture where it becomes easy to control privileges to users of different job role.
Views: 208 Subhroneel Ganguly
SQL tutorial 32: How To Insert Data into a Table Using SQL Developer
 
05:16
SQL Tutorial 32 How To Insert Data into a Table Using SQL Developer and How to delete Data/Row From a table. Website : http://www.RebellionRider.com New Series of #SQL tutorial on How to Insert Data. I'll cover all the traditional way along with some tips and tricks on Data insertion. Keep watching and enjoy #SQLing Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=j7eYO7 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 www.RebellionRider.com
Views: 54754 Manish Sharma
SQL, How to create a user  in oracle database, 2e54
 
08:36
The video will show how to create a user with the help of SQL in oracle database.
Views: 1997 hammadshams
SQL, Oracle, Dual table, 3e62
 
07:37
Understanding Dual table. Most SQL videos are available on www.my-uni.net also. Feel free to visit
Views: 2765 hammadshams
Tutorial : Concepts of Oracle APEX Workspace, Users and Applications
 
25:17
This Tutorial discusses about concepts of Apex Workspace, Users and Applications.
Views: 1325 Oracle Testlab
ORACLESQL02 - create table, sequence, grant on table to user
 
04:23
Kod SQL: http://pastebin.com/MEUHjwjK Tworzenie tabeli game na koncie kubus, przeglądanie jej zawartości na nowoutworzonym koncie zygmunt
Oracle SQL 13  How to Creating a sequence USING SQL COMMAND
 
11:25
CREATE TABLE command in sql/oracle,INSERT command in sql/oracle UPDATE,ALTER PASSWORD command in sql, GRANT command, REVOKE command i, CREATE SYNONYM command in sql/oracle, DELETE command in sql/oracle, ALTER TABLE command in sql/oracle, DROP TABLE command in sql/oracle, CREATE INDEX command in sql/oracle, ALTER INDEX command in sql/oracle, DROP INDEX command in sql/oracle, CREATE VIEW command in sql/oracle, DROP VIEW command in sql/oracle, Types of SQL Commands The following sections discuss the basic categories of commands used in SQL to perform various functions. These functions include building database objects, manipulating objects, populating database tables with data, updating existing data in tables, deleting data, performing database queries, controlling database access, and overall database administration. The main categories are DDL (Data Definition Language) DML (Data Manipulation Language) DQL (Data Query Language) DCL (Data Control Language) Data administration commands Transactional control commands Defining Database Structures Data Definition Language, DDL, is the part of SQL that allows a database user to create and restructure database objects, such as the creation or the deletion of a table. Some of the most fundamental DDL commands discussed during following hours include the following: CREATE TABLE ALTER TABLE DROP TABLE CREATE INDEX ALTER INDEX DROP INDEX CREATE VIEW DROP VIEW These commands are discussed in detail during Hour 3, "Managing Database Objects," Hour 17, "Improving Database Performance," and Hour 20, "Creating and Using Views and Synonyms." Manipulating Data Data Manipulation Language, DML, is the part of SQL used to manipulate data within objects of a relational database. There are three basic DML commands: INSERT UPDATE DELETE These commands are discussed in detail during Hour 5, "Manipulating Data." Selecting Data Though comprised of only one command, Data Query Language (DQL) is the most concentrated focus of SQL for modern relational database users. The base command is as follows: SELECT This command, accompanied by many options and clauses, is used to compose queries against a relational database. Queries, from simple to complex, from vague to specific, can be easily created. The SELECT command is discussed in exhilarating detail during Hours 7 through 16. A query is an inquiry to the database for information. A query is usually issued to the database through an application interface or via a command line prompt. Data Control Language Data control commands in SQL allow you to control access to data within the database. These DCL commands are normally used to create objects related to user access and also control the distribution of privileges among users. Some data control commands are as follows: ALTER PASSWORD GRANT REVOKE CREATE SYNONYM You will find that these commands are often grouped with other commands and may appear in a number of different lessons throughout this book. Data Administration Commands Data administration commands allow the user to perform audits and perform analyses on operations within the database. They can also be used to help analyze system performance. Two general data administration commands are as follows: START AUDIT STOP AUDIT Do not get data administration confused with database administration. Database administration is the overall administration of a database, which envelops the use of all levels of commands. Database administration is much more specific to each SQL implementation than are those core commands of the SQL language. Transactional Control Commands In addition to the previously introduced categories of commands, there are commands that allow the user to manage database transactions. COMMIT Saves database transactions ROLLBACK Undoes database transactions SAVEPOINT Creates points within groups of transactions in which to ROLLBACK SET TRANSACTION Places a name on a transaction Transactional commands are discussed extensively during Hour 6, "Managing Database Transactions."
Extended Data Types in Oracle Database 12c Onward
 
03:13
This video gives a quick demonstration of the Extended Data Types functionality available from Oracle Database 12c onward. For more information see: Extended Data Types in Oracle Database 12c Release 1 (12.1) https://oracle-base.com/articles/12c/extended-data-types-12cR1 Website: https://oracle-base.com Blog: https://oracle-base.com/blog Twitter: https://twitter.com/oraclebase Cameo by Martin Klier : Blog: https://www.performing-databases.com/blog/ Twitter : https://twitter.com/MartinKlierDBA Cameo appearances are for fun, not an endorsement of the content of this video. All trademarks, product names and logos are the property of their respective owners.
Views: 418 ORACLE-BASE.com
APEX04 of 30: Use SQL Workshop in APEX to run scripts that insert data into tables.
 
14:42
APEX 18.1 video 4 of 30: This video shows how to use “SQL Scripts,” which is part of SQL Workshop, to run scripts that insert data into tables. We also see an example of what happens if you try to run the same script twice (the DBMS keeps us from inserting the same data twice) and we can an example of an error that might occur when inserting data. We also use the “Data Workshop” component of SQL Workshop to import data from a simple text file and put it in a table. Scripts are at: http://db.kreie.net
Views: 1164 Jennifer Kreie
Oracle DBA Justin - How to drop/delete an Oracle database
 
09:03
How to delete/drop an Oracle database
Views: 15584 jbleistein11
Creating a User and Privileges using Enterprise Manager Express
 
02:04
Oracle University instructor Darryl Balaski discusses creating users and privileges using Enterprise Manager Express.
Oracle DBA Justin - How to drop/delete a user account from an Oracle database
 
07:41
How to drop/delete a user account from an Oracle database
Views: 5793 jbleistein11
Oracle Tutorial ||online training|| Oracle|Adv Sql | Table Locks Part - 2 by basha
 
33:30
DURGASOFT is INDIA's No.1 Software Training Center offers online training on various technologies like JAVA, .NET , ANDROID,HADOOP,TESTING TOOLS ,ADF,INFORMATICA,TABLEAU,IPHONE,OBIEE,ANJULAR JS, SAP... courses from Hyderabad & Bangalore -India with Real Time Experts. Mail us your requirements to [email protected] so that our Supporting Team will arrange Demo Sessions. Ph:Call +91-8885252627,+91-7207212428,+91-7207212427,+91-8096969696. http://durgasoft.com http://durgasoftonlinetraining.com https://www.facebook.com/durgasoftware http://durgajobs.com https://www.facebook.com/durgajobsinfo......