Home
Search results “Grant create on 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: 23477 Manish Sharma
Oracle SEQUENCES - Beginner
 
12:50
Oracle SEQUENCES - Beginner
Views: 11998 Chris Ostrowski
57. Create, Alter and Drop Sequence in Oracle
 
04:38
In this video you will learn about creating, altering and dropping sequence in Oracle. Sequence help us quickly generate next number and used with INSERT statement. It can generate sequence and series of numbers. 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: 19278 ITORIAN
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: 530 Jennifer Kreie
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: 11662 Oracle World
Oracle - grant and revoke
 
05:28
Oracle - grant and revoke
Views: 7521 Chris Ostrowski
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: 190 Subhroneel Ganguly
APEX01 of 30: Create a schema in Oracle XE and create a workspace in APEX
 
07:21
APEX 18.1 video 1 of 30: This video shows the commands used to create a schema (account) in Oracle XE and how to create a workspace in APEX that uses that schema. Scripts for the videos are at: http://db.kreie.net
Views: 643 Jennifer Kreie
grant and revoke in oracle
 
06:42
in this tutorial i teach grant and revoke in oracle
Oracle SYNONYMS - beginner
 
09:21
Oracle SYNONYMS - beginner
Views: 7824 Chris Ostrowski
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: 175815 Manish Sharma
Oracle - Managing Views, Sequences, Synonyms, and Index
 
03:18
Oracle - Managing Views, Sequences, Synonyms, and Index
Views: 242 Si Ruy
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 Create User statement in 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 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: 40590 Manish Sharma
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 tutorial : Grant Revoke In Oracle
 
13:32
Oracle tutorial : Grant Revoke In Oracle we can GRANT and REVOKE privileges on various database objects in Oracle. Example : on Tables ,functions ,procedures etc. Syntax : GRANT privileges ON object TO user; example : GRANT SELECT, INSERT, UPDATE, DELETE ON TEST TO MYDEV; or GRANT ALL ON TEST TO MYDEV; REVOKE PRIVILEGES ON TABLE Syntax : REVOKE privileges ON object FROM user; REVOKE DELETE ON TEST FROM MYDEV; REVOKE ALL ON TEST FROM MYDEV; For more tutorial please visit #techquerypond https://techquerypond.com https://techquerypond.wordpress.com https://twitter.com/techquerypond
Views: 1266 Tech Query Pond
How to Configure AME in R12 - Assign Roles & Create Grants for User
 
07:01
How to Configure AME in R12 - Assign Roles & Create Grants for User In this video, I have explained how to Configure AME in Oracle R12. 1. Assign Roles to User 2. Create Grant Option For Learning Oracle E-Business Suite.. Check below sites. http://www.oracleerpappsguide.com https://www.facebook.com/LearnOracleErpAppsGuide/ https://plus.google.com/u/0/communities/111267855409088676081 Email: [email protected] Happy Learning!.
Views: 25119 Oracle ERP Apps Guide
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: 1995 hammadshams
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: 314 Dantee Astudillo
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 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: 21821 jbleistein11
ORACLE SQL 45: Create & Drop Sequence
 
06:37
http://studyandshare.wordpress.com/ http://www.facebook.com/groups/studyandsharevn/
Views: 2475 studyandsharevn
Часть 0. Oracle Database. Установка Oracle Linux 7 1 в Virtual Box и установка Oracle XE
 
01:10:53
Видео-мануал по установке Oracle Linux в VirtualBox и установка Oracle XE. Содержимое файлов настроек и скрипты: Содержимое файла .bash_profile. Открываем: nano /root/.bash_profile Вставляем: #Oracle install specific environment settings umask 022 TMP=/tmp; export TMP TMPDIR=$TMP; export TMPDIR ORACLE_HOSTNAME=localhost.localdomain; export ORACLE_HOSTNAME ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe; export ORACLE_HOME ORACLE_SID=orcl; export ORACLE_SID ORACLE_TERM=xterm; export ORACLE_TERM PATH=$ORACLE_HOME/bin:/usr/sbin:$PATH; export PATH LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH CLASSPATH=$CLASSPATH:$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH NLS_LANG=AMERICAN_AMERICA.CL8MSWIN1251; export NLS_LANG Ctrl+O сохранить, Ctrl+X выйти из nano. В mc - F4 редактировать файл, F2 - сохранить, F10 выйти Открываем порт 1521 и 8080 в Firewall на Oracle Linux 7.1: firewall-cmd --zone=public --add-port=1521/tcp --permanent ; firewall-cmd --zone=public --add-port=8080/tcp --permanent ; firewall-cmd --reload ; firewall-cmd --zone=public --list-ports Должно быть так: success success success 1521/tcp 8080/tcp Команды создания пользователя вставляем в SQL Navigator или SQL Developer: --DROP USER analytic CASCADE; --Это удаление пользователя и всех его данных. CREATE USER analytic IDENTIFIED BY 123456; --123456 - это пароль. GRANT CREATE SESSION TO analytic; --право подключаться. Ѕез него невозможно залогиниться в Oracle --под этим пользователем. GRANT CREATE TABLE TO analytic; --право создавать таблицы GRANT CREATE PROCEDURE TO analytic; --право создавать процедуры GRANT CREATE TRIGGER TO analytic; --право создавать триггеры GRANT CREATE VIEW TO analytic; --право создавать представления GRANT CREATE SEQUENCE TO analytic; --право создавать последовательности GRANT CREATE LIBRARY TO analytic; --право создавать внешние процедуры/библиотеки GRANT CREATE ANY DIRECTORY TO analytic; GRANT DROP ANY DIRECTORY TO analytic; --право создавать, удалять, читать и писать в директории GRANT CREATE PUBLIC SYNONYM TO analytic; GRANT EXECUTE ON SYS.UTL_HTTP TO analytic; GRANT EXECUTE ON SYS.UTL_FILE TO analytic; GRANT EXECUTE ON SYS.utl_smtp TO analytic; GRANT EXECUTE ON SYS.utl_xml TO analytic; --права на использование пакетов ALTER USER analytic QUOTA UNLIMITED ON USERS; ALTER USER analytic QUOTA UNLIMITED ON SYSTEM; --раздаем квоты на использование места - неограничено. COMMIT; --подтверждение сделанных в данной сессии операций Access Control List не могу опубликовать, с видео тащите. Гугл не позволяет писать скобки в описании видео. Но в принципе ACL и не нужен большинству из вас.
Oracle 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;
Sql Tutorial - How to create Views in oracle database
 
22:59
Hi friends in my today scenario i explaining how to create view in SQL and how view help to improve performance of SQL query. #SqlTutorial #createViewsinoracle Oracle database Unbeatable,Unbreakable Platform..
Views: 5266 Oracle World
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: 302 ActiveKite
Oracle Tutorials : 5 - CREATE / DROP TABLE
 
07:00
Oracle Tutorials : 5 - CREATE / DROP TABLE
Views: 1098 Meganadha Reddy
Oracle Sequences and Synonyms
 
21:11
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 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: 27731 Manish Sharma
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: 5110 jbleistein11
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: 3710 Ahmed Tartour
Oracle -11g -Sql -Create table in Database -1
 
10:01
Khunkhun Product 1-SQL TYPE -DDL(CREATE ,ALTER,DROP ) ,DML (INSERT ,UPDATE,DELETE), DQL(USED TO RETRIVE THE DATA FROM TABLE FOR READ ONLY PURPOUS) , DCL(GRANT,REVOKE) ,TCL(COMMIT,ROLLBACK) 1 HOW TO CREATE A TABLE- 2- Insert the Record 1-DDL – Data Definition Language 2-DML –Data Manipulation Language 3- DQL-Data querying Language 4-DCL-Data Control Language 5-TCL –Transction Control Language
Views: 281 khunkhun Product
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: 36 Jesus Hidalgo
032-Oracle SQL Arabic Course  - Sequence اوراكل ديفلوبر
 
04:42
Oracle SEQUENCES - Beginner .......................................­.................... تواصل معانا علي الفيس بوك من هنا : https://www.facebook.com/askgad .......................................­.................... تواصل معانا علي موقعنا من هنا : https://www.askgad.com/
Views: 1432 Ask Gad
How to create Document sequence in Oracle Fusion GL R13
 
09:51
Document Sequence in Fusion cloud GL There are two types of Sequence 1. Accounting Sequence 2.Reporting Sequence. Accounting sequence used while posting the GL Journals Reporting Sequence used during period close in GL -~-~~-~~~-~~-~- Please subscribe to our channel to get One week Free Access to Oracle Fusion Instance My Techno Journal is a Technology channel and purely dedicated to latest Technology development,Tech news, Cloud Technology, Day to day development in digital life. This channel will specifically focus on Oracle Cloud Technology and other interesting Tech innovation and bring out interesting technology fact to its audience My Techno Journal will provide to its audience with Video Guides and training materials, Oracle tutorial for various technology like Oracle EBS and cloud Financial,Oracle Supply Chain Management ,Oracle EBS Cloud and Human Resource management,Oracle EBS and Cloud Technical resources including Oracle Application framework,Oracle Development Framework and PLSQL. My Techno Journals will also bring up with training material for other contemporary and useful business Software . Time to Time the channel people will observe and review the latest trending technology stuff and development related to computer,business,laptop,mobile,android apps,startup initiatives etc. Like us in Twitter https://twitter.com/MyTechnoJournal Like us in Facebook https://www.facebook.com/mytechnojournalcom-125065171496060/ -~-~~-~~~-~~-~-
Views: 621 MY TECHNO JOURNAL
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: 24518 Manish Sharma
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: 544 brijesh kumar
Grant
 
02:01
How to give a special privileges to oracle user in oracle database in urdu.
Views: 2973 modern IT Channel
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: 7994 Parag Mahalle
How to Create an user in Oracle
 
14:49
How to Create an user in Oracle with minimum grants/privileges we need to connect as SYSDBA lets ceate an user test you can see the user is created : But can it connect? lets open a new session we can see it lacks create session priv. so, we grant the create session privilege to user test lets test Its connecting. But is it able to create a table ,lets check. it lacks the ability to create table. SO lets give the privilege. lets test again the create table command. its throwing error regarding no Privilege on users tablespace . But we have given USERS as the default tablespace to test(user). So whats the problem? The problem is there is not quota defined for user test. lets give some quota like "10MB" or UNLIMITED , we will giev 10MB NOw let us test. So we can see that we now have sufficient / minimum privileges for the user test. Hope this will help in understanding the concept behind user creation
Views: 99 OracleDBA
Oracle DBA Justin - How to create a proxy user
 
11:59
How to create a proxy user
Views: 3865 jbleistein11
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: 163 Sanz
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: 1258 hammadshams
05 Creacion de Tablespace y Usuario en Oracle 11g
 
11:27
Se explica en forma breve como crear tablespace para los datos, indices y archivos temporales. Además de crear un usuario con la finalidad de que este genere posteriormente un esquema relacional. SCRIPT: CREATE TABLESPACE PERSONA_DATA DATAFILE '/opt/baseDatos/DT_PERSONAS.DBF' SIZE 200M; CREATE TEMPORARY TABLESPACE PERSONA_TEMP TEMPFILE '/opt/baseDatos/DT_PERSONAS_TMP.DBF' SIZE 200M; CREATE TABLESPACE PERSONA_INDEX DATAFILE '/opt/baseDatos/DT_PERSONAS_IDX.DBF' SIZE 200M; SELECT * FROM DBA_DATA_FILES; 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 PERSONA_BD IDENTIFIED BY PERSONA_BD DEFAULT TABLESPACE PERSONA_DATA TEMPORARY TABLESPACE PERSONA_TEMP; --DAR PERMISOS AL USUARIO ADMINISTRADOR_BD SOBRE TABLESPACES GRANT UNLIMITED TABLESPACE TO PERSONA_BD; --VOLCAR ADMINISTRADOR_BD A COLECCIONES GRANT ADMINISTRADOR_BD TO PERSONA_BD;
SQL Views, Create Views, DROP Views - SQL Tutorial for Beginners
 
04:53
SQL Views, Create Views, DROP Views - SQL Tutorial for Beginners SQL tutorial for Beginners in Hindi and English
Oracle Tuning - Criando SCHEMA para teste de carga
 
06:49
Oracle Tuning - Criando SCHEMA para teste de carga
Views: 777 Nerv
Descarga-Instalación ORACLE Express 11g, SQLdeveloper || CREAR TABLESPACE -DATAFILE- USER
 
11:09
Espero les guste amigos y les sirva de ejemplo en su creación de tablespaces, datafiles, usuario y contraseña. Aquí les dejo el script del código para poder crearlos: CREATE TABLESPACE PERSONA_DATAejem DATAFILE 'C:\oraclexe\app\oracle\oradata\XE\Personadataejem.DBF' SIZE 200M; CREATE TEMPORARY TABLESPACE PERSONA_TEMP TEMPFILE 'C:\oraclexe\app\oracle\oradata\XE\Personatemp.DBF' SIZE 200M; CREATE TABLESPACE PERSONA_INDEX DATAFILE 'C:\oraclexe\app\oracle\oradata\XE\Personaind.DBF' SIZE 200M; SELECT * FROM DBA_DATA_FILES; 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 PERSONA_BD IDENTIFIED BY PERSONA_BD DEFAULT TABLESPACE PERSONA_DATAejem TEMPORARY TABLESPACE PERSONA_TEMP; --DAR PERMISOS AL USUARIO ADMINISTRADOR_BD SOBRE TABLESPACES GRANT UNLIMITED TABLESPACE TO PERSONA_BD; --VOLCAR ADMINISTRADOR_BD A COLECCIONES GRANT ADMINISTRADOR_BD TO PERSONA_BD;
Views: 29 kevin surf
Oracle - Synonyms
 
10:43
Oracle - Synonyms
Views: 8296 Chris Ostrowski
How to use Oracle Live SQL?
 
07:41
In this video, you are going to learn how to use Oracle Live SQL and how to work with Oracle Database without installing the database. To learn using Oracle Live SQL and more : https://www.udemy.com/oracle-sql-12c-become-an-sql-developer-with-subtitle/?couponCode=YOUTUBESAVE95 Oracle SQL : Become a Certified SQL Developer From Scratch! Learn SQL with a "Professional Certification Course", Hundreds of Examples including 3 Real Exam Samples(225 Questions)! Oracle Database 12c SQL Certified Associate 1Z0-071

Medroxyprogesterone acetate provera 10mg prescription
Minocycline tablets bp 100mg thc
Cloro alergan 4 mg dosis
Tetracycline 250 mg dosis de amoxicilina
Can 300 mg of seroquel kill you