4th SQL Tutorial in the series of user privileges in oracle database user Roles in Oracle Database. In this tutorial you will learn
● What user roles
● How to create simple roles (Role with Not Identified clause)
● How to create secure roles (Role with Identified clause)
● How to create external role.
● How To create global role.
● How to Grant System Privilege to a user Role
● How to Grant Object Privilege to a user Role In oracle database.
● How to grant a Role to another Role
● How To grant a role to database users (with Admin option)
● How To enable role using SET ROLE statement
This video will teach you the concept of user role in oracle database which is an extension to the user privileges. In this video I did 10 SQL queries on user Roles which makes this tutorial fun.
Celebrating 1000 subscribers. Thanks a lot guys for all your love and support.
------------------------------------------------------------------------
►►►LINKS◄◄◄
Blog: http://bit.ly/create_role_in_oracle
System Privilege: http://youtu.be/EQzdtKPiErU
Object Privilege: http://youtu.be/DuDL7NTPdqQ
-------------------------------------------------------------------------
Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage
https://copy.com?r=kb4rc1
--------------------------------------------------------------------------
►Make sure you SUBSCRIBE and be the first one to see my videos!
--------------------------------------------------------------------------
Amazon Wishlist: http://bit.ly/wishlist-amazon
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
►►►Find me on Social Media◄◄◄
Follow What I am up to as it happens on
https://twitter.com/rebellionrider
https://www.facebook.com/imthebhardwaj
http://instagram.com/rebellionrider
https://plus.google.com/+Rebellionrider
http://in.linkedin.com/in/mannbhardwaj/
http://rebellionrider.tumblr.com/
http://www.pinterest.com/rebellionrider/
You can also Email me at
[email protected]
Please please LIKE and SHARE my videos it makes me happy.
Thanks for liking, commenting, sharing and watching more of our videos
This is Manish from RebellionRider.com
♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS

how to create user ,drop user,grant permissions to user?
this video completely describes and show you creation ,droping,modifying users in oracle 11g using sqlplus..
the people who new to oracle can easily understand this..it may help you in future reference and complete understanding of user creation ,modfying etc..
in furthur videos i will explain grant,revoke permissions to users fro m admin user
so please subscribe and like for future update
https://www.youtube.com/user/prasadamudalapalli
how to create Hibernate App and Save data in data table?
how to download Eclipse-oxygen in windows7?
how to uninstall oracle 11g in windows 7?
how to download oracle 11g 64 bit in windows 7?
how to step java project in Eclipse oxygen?
how to configure tomcate server 9.0 in Eclipse oxygen?
how to open and connect sqlplus in windows7?
how to download ,install and connect sqldeveloper?
how to create ,drop ,modifer user in oracle 11g?

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

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

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

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

Learn another DBA trick. In this tutorial you will learn how to create an user actually an External user / schema. Being an Oracle DBA you must know how to create an external user/ schema
Celebrating 1000 subscribers. Thanks a lot guys for all your love and support.
------------------------------------------------------------------------
►►►LINKS◄◄◄
Website: http://bit.ly/how-to-create-external_user-oracle
Previous Tutorial: How to unlock user using SQL Developer
http://youtu.be/xRBfeTO1Pc8
Tutorial 38: http://youtu.be/GS4udgR44Ls
Links of how to create user tutorial
Create user using SQL Developer
http://youtu.be/GS4udgR44Ls
Create user using Create user command
http://youtu.be/4QbK2Y-1LZw
Create user using EM
http://youtu.be/zGjh-Bb3HrI
-------------------------------------------------------------------------
Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage
https://copy.com?r=kb4rc1
--------------------------------------------------------------------------
►Make sure you SUBSCRIBE and be the first one to see my videos!
--------------------------------------------------------------------------
Amazon Wishlist: http://bit.ly/wishlist-amazon
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
►►►Find me on Social Media◄◄◄
Follow What I am up to as it happens on
https://twitter.com/rebellionrider
https://www.facebook.com/imthebhardwaj
http://instagram.com/rebellionrider
https://plus.google.com/+Rebellionrider
http://in.linkedin.com/in/mannbhardwaj/
http://rebellionrider.tumblr.com/
http://www.pinterest.com/rebellionrider/
You can also Email me at
[email protected]
--------------------------------------------------------------------------
►Connect with me on my LinkedIn and please endorse my skills
Thanks in Advance http://in.linkedin.com/in/mannbhardwaj/
--------------------------------------------------------------------------
Please please LIKE and SHARE my videos it makes me happy.
Thanks for liking, commenting, sharing and watching more of our videos
This is Manish from RebellionRider.com
♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS

Privilege analysis captures privileges used by database users and applications at runtime. You then can revoke unused grants and other changes to better reflect the access a user requires. This simplifies the work required to implement least privilege practice.
A recent change to the license terms makes privilege analysis available to ANY of our Enterprise Edition database customers (on-premises or in the cloud) at no additional cost. Learn how privilege analysis works, the use cases for privilege analysis, and how you can use privilege analysis to shrink your attack surface and better manage user privileges in your database.
Timing for the video:
0:58 - Announcements
6:15 - Overview of Privilege Analysis
15:20 - Live demo of Privilege Analysis
42:00 - Q&A
AskTOM Office Hours offers free, monthly training and tips on how to make the most of Oracle Database, from Oracle product managers, developers and evangelists.
https://asktom.oracle.com/
Oracle Developers portal: https://developer.oracle.com/
Sign up for an Oracle Cloud trial: https://cloud.oracle.com/en_US/tryit

SQL tutorial on How to unlock user or schema in oracle database or how to unlock hr account/user/schema in oracle database using alter user SQL command. you can use the steps to change the password of any user in oracle database explained in detail.
Celebrating 1000 subscribers. Thanks a lot guys for all your love and support.
-------------------------------------------------------------------------
Blog Link: http://bit.ly/unlock-user-in-oracle
--------------------------------------------------------------------------
►Make sure you SUBSCRIBE and be the first one to see my
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Follow What I am up to as it happens on
https://twitter.com/rebellionrider
https://www.facebook.com/imthebhardwaj
http://instagram.com/rebellionrider
https://plus.google.com/+Rebellionrider
http://in.linkedin.com/in/mannbhardwaj/
http://rebellionrider.tumblr.com/
http://www.pinterest.com/
Please please LIKE and SHARE my videos it makes me happy.
Thanks for liking, commenting, sharing and watching more of our videos
This is Manish from RebellionRider.com
♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS

Import schema objects:
The Export and Import utilities provide a simple way for you to transfer data objects between Oracle databases, even if they reside on platforms with different hardware and software configurations.
When you run Export against an Oracle database, objects (such as tables) are extracted, followed by their related objects (such as indexes, comments, and grants), if any. The extracted data is written to an export dump file. The Import utility reads the object definitions and table data from the dump file.
An export file is an Oracle binary-format dump file that is typically located on disk or tape. The dump files can be transferred using FTP or physically transported (in the case of tape) to a different site. The files can then be used with the Import utility to transfer data between databases that are on systems not connected through a network. The files can also be used as backups in addition to normal backup procedures.
Export dump files can only be read by the Oracle Import utility. The version of the Import utility cannot be earlier than the version of the Export utility used to create the dump file.
Follow me:
https://www.facebook.com/Oracle-DB-592800217490198/
Oracle Database 11g: Export schema objects
Oracle Database11g: How to uninstall oracle 11g from windows 7 | Uninstall 11g | Deinstall 11g
How to install Oracle Database 11g on windows 7 easy and step by step

Export schema objects:
The Export and Import utilities provide a simple way for you to transfer data objects between Oracle databases, even if they reside on platforms with different hardware and software configurations.
When you run Export against an Oracle database, objects (such as tables) are extracted, followed by their related objects (such as indexes, comments, and grants), if any. The extracted data is written to an export dump file. The Import utility reads the object definitions and table data from the dump file.
An export file is an Oracle binary-format dump file that is typically located on disk or tape. The dump files can be transferred using FTP or physically transported (in the case of tape) to a different site. The files can then be used with the Import utility to transfer data between databases that are on systems not connected through a network. The files can also be used as backups in addition to normal backup procedures.
Export dump files can only be read by the Oracle Import utility. The version of the Import utility cannot be earlier than the version of the Export utility used to create the dump file.
Follow me:
https://www.facebook.com/Oracle-DB-592800217490198/
Oracle Database 11g: Import schema objects
Oracle Database11g: How to uninstall oracle 11g from windows 7 | Uninstall 11g | Deinstall 11g
How to install Oracle Database 11g on windows 7 easy and step by step

In this tutorial you will learn how to unlock, change, access a locked user account's password.
To unlock a user that is locked or expired, connect using SYS (DBA).
After successfully connected, click Schema Browser.
Then find Users from list box.
You will see a cross left side of the locked user. Double click the username that is locked or expired.
Enter the new password in the opening window. Don't forget to uncheck Password Expired box.
Now you can connect with the user that is unlocked.
Thank you for watching.

Learn how to unlock HR user / Schema in Oracle Database 12c. Step by step procedure of unlocking the HR Schema in Oracle 12c By Manish Sharma a.k.a RebellionRider
------------------------------------------------------------------------
►►►LINKS◄◄◄
Blog : http://bit.ly/how-to-unlock-hr-user-in-oracle-database-12c
Previous Tutorial
► Tut 60: How To Install 12c On Windows 7:
http://youtu.be/T-rCbe1MMG4
-------------------------------------------------------------------------
►►►Help Me In Getting A Job◄◄◄
►Help Me In Getting A Good Job By Connecting With Me on My LinkedIn and Endorsing My Skills. All My Contact Info is Down Below. You Can Also Refer Me To Your Company
Thanks
-------------------------------------------------------------------------
Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage
https://copy.com?r=kb4rc1
--------------------------------------------------------------------------
►Make sure you SUBSCRIBE and be the 1st one to see my videos!
--------------------------------------------------------------------------
Amazon Wishlist: http://bit.ly/wishlist-amazon
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
►►►Find me on Social Media◄◄◄
Follow What I am up to as it happens on
https://twitter.com/rebellionrider
https://www.facebook.com/imthebhardwaj
http://instagram.com/rebellionrider
https://plus.google.com/+Rebellionrider
http://in.linkedin.com/in/mannbhardwaj/
http://rebellionrider.tumblr.com/
http://www.pinterest.com/rebellionrider/
You can also Email me at
[email protected]
Please please LIKE and SHARE my videos it makes me happy.
Thanks for liking, commenting, sharing and watching more of our videos
This is Manish from RebellionRider.com
♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS

How to create mysql database, create user, grant all privileges to this user to new database via console using putty client.
https://root.zt.ua/sozdanie-bazy-dannyh-mysql-i-dobavlenie-polzovatelya-s-pravami-cherez-konsol/

How Enter New Supplier Records in Oracle Apps R12 using Data Loader
Forms Data Loader fills data in Forms by simulating keystrokes as though type by a user. It provides a spreadsheet interface where you can enter the data and keystrokes to send to the forms. Building Load is quite easy, you can learn building data loads by just spending few minutes. We provide a series of demos which demonstrates how the loads are developed and how FDL works. Although it is specially focused to load data into Oracle ERP Applications, it can be used to load data in virtually any type of application form whether it is SAP or HTML or any other application
Click : http://www.formsdataloader.com