Home
Search results “Oracle connections or sessions”
Oracle DBA Justin - How to kill a user session connected to an Oracle database
 
07:32
How to kill a user session connected to an Oracle database
Views: 8069 jbleistein11
Oracle || Oracle Session-1 by Dinesh
 
58:29
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.......
Views: 226724 Durga Software Solutions
How to Monitor Session in SQL Developer | Oracle SQL Developer Tips and Tricks
 
04:10
How to Monitor Session in Oracle SQL Developer | Oracle SQL Developer Tips and Tricks Oracle SQL Tutorial for Beginners, Oracle Database Tutorial for Beginners, Oracle SQL Developer Tips and Tricks, Oracle Tutorial for Beginners, Oracle Tutorial How to Monitor Session in SQL Developer, How to Monitor Session Using SQL Developer, How to Monitor Session in Oracle SQL Developer, How to Monitor Session Using Oracle SQL Developer, how to check number of connections in oracle, how to check active sessions in oracle, oracle sql developer real time sql monitoring, how to check active session in oracle 11g, sql developer monitor sessions table or view does not exist oracle monitor sql statements how to check query performance in oracle sql developer
Views: 941 Oracle PL/SQL World
Oracle ASM Administration - Session 1
 
01:13:46
https://dbagenesis.com/p/oracle-11gr2-rac-for-beginners DBA Genesis provides all you need to build and manage effective Oracle technology learning. We designed DBA Genesis as a simple to use yet powerful online Oracle learning system for students. Each of our courses is taught by an expert instructor, and every course is available on demand. Oracle ASM administration is very important for an Oracle RAC DBA. This video is shared from one of our online RAC DBA training.
Views: 56012 DBA Genesis
Kamil Stawiarski - Oracle Hacking Session
 
48:46
The live demo, presenting a real-life experience in penetration testing of the consolidated Exadata database environment for one of my customers. In the short session I’ll try to show the threats of the consolidation era and how to make the environment more secure. The key aspect of my presentation will be escalating privileges from CREATE ANY INDEX to executing any command as an oracle user in operating system, through the SQL engine.
Views: 514 Riga Dev Days
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: 2577 jbleistein11
Oracle R12 Financials Training | 1st Session
 
01:15:22
Oracle R12 Financials Online Training for Beginners: 120 Hours Classes, Contact us: India Numbers: +91-88860 96632, 96661 83940 Mail: [email protected], Web: WWW.ERPTREE.COM
Oracle developer 11g Session 1
 
02:19:05
Support my fan Please https://www.facebook.com/Learnoraclewithward Very Important choose Settings and choose Quality 720 HD To Watch High Quality and when Download also To have Good Quality More video about Oracle developer Please join Facebook fan Learn Oracle with Ward Oracle Please add Like to share with your friends Direct Link https://www.facebook.com/pages/Learn-Oracle-With-Ward/261884427295734 Thanks Ahmed Ward
Views: 39034 Ahmed Ward
Oracle / Acme Packet  Session Border Controller Simplified Configuration Part I: Concepts
 
06:43
In this tutorial, we discussed certain Oracle/Acme packet session border controller concepts and got to a point where we can now focus on configuring an SBC. If you have any questions/ comments please use the comments section below. For tutorial suggestions/requests, please send us the details by using the contact section of our website, http://www.SIPtopia.org
Views: 9530 SIPtopia.org
Oracle Database Backup and Recovery Session 1
 
02:38:11
https://dbagenesis.com/p/oracle-advanced-rman-backup-recovery DBA Genesis provides all you need to build and manage effective Oracle technology learning. We designed DBA Genesis as a simple to use yet powerful online Oracle learning system for students. Each of our courses is taught by an expert instructor, and every course is available on demand. MASTER AND LEARN - Backup and Recovery Overview - Cold Database Backup - Hot Database Backup - Manual Database Recovery
Views: 160035 DBA Genesis
How to find Oracle Database locked session using Oracle Enterprise Manager 12C
 
02:09
Video tutorial on how to find Oracle Database locked session using Oracle Enterprise Manager 12C. For more Database Administration articles and scripts go to www.aodba.com & www.verticablog.com More Articles, Scripts and How-To Papers on http://www.aodba.com
Views: 5276 AO DBA
Oracle Financials Training  | 1st Session | New Batch Started
 
01:16:14
Oracle Financials Training, Oracle R12 Finance Training, Oracle R12 Financials Functional Training Contact us: US Number: +1 646 491-6833, India Numbers: +91-88860 96632, 96661 83940, Mail: [email protected]
Oracle Database Backup and Recovery Session 2
 
02:19:30
https://dbagenesis.com/p/oracle-advanced-rman-backup-recovery DBA Genesis provides all you need to build and manage effective Oracle technology learning. We designed DBA Genesis as a simple to use yet powerful online Oracle learning system for students. Each of our courses is taught by an expert instructor, and every course is available on demand. MASTER AND LEARN: - Introduction to RMAN - Configuring RMAN - Database Backup using RMAN - RMAN Database Recovery
Views: 57048 DBA Genesis
Generate ASH (Active session history) report in Oracle Manually in 11g
 
03:56
Why and How we generate ASH Report in Oracle 11g
Views: 2588 Athar Fahad
Oracle Database Tuning Introduction - Session 1
 
35:46
This is the first lecture of the Oracle Database Troubleshooting and Tuning Class. The Full course is available on Udemy at https://www.udemy.com/oracle-database-troubleshooting-and-tuning You can use Coupon Code YOUTUBETT for discount Our Upcoming Online Course Schedule is available in the url below https://docs.google.com/spreadsheets/d/1qKpKf32Zn_SSvbeDblv2UCjvtHIS1ad2_VXHh2m08yY/edit#gid=0 Reach us at [email protected]
Views: 2866 Ramkumar Swaminathan
Best way to kill an Oracle Database session.
 
02:50
Best way to kill an Oracle database session. Music: https://www.bensound.com
Views: 183 ORA-600
Oracle || Oracle Session-2 by Dinesh
 
34:13
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 12c Administration Demo Session
 
45:34
For complete professional training visit at: http://www.bisptrainings.com/course/Oracle-12c-Administration Register here:http://www.bisptrainings.com/registration/Oracle-12c-Administration Follow us on Facebook: https://www.facebook.com/bisptrainings/ Follow us on Twitter: https://twitter.com/bisptrainings Email: [email protected] Call us: +91 975-275-3753 or +1 386-279-6856
Views: 3524 Amit Sharma
Oracle Fusion SCM Training | Introduction | 1st Session
 
01:29:12
Oracle Fusion Cloud SCM (Supply Chain Management) Online Training, Oracle Fusion SCM Training Contact us: USA Number: +1 646 491-6833, India Numbers: +91-88860 96632, 96661 83940 http://www.erptree.com/ Mail: [email protected]
Session Sequences in Oracle 12c
 
01:53
This video shows the performacne improvements associated with session sequences in Oracle 12c. For more information see: https://oracle-base.com/articles/12c/session-sequences-12cr1 Website: https://oracle-base.com Blog: https://oracle-base.com/blog Twitter: https://twitter.com/oraclebase Cameo by Peter Scott Blog: https://dwpetetechnical.wordpress.com/ Twitter: https://twitter.com/dw_pete Cameo appearances are for fun, not an endorsement of the content of this video.
Views: 741 ORACLE-BASE.com
Oracle 11g Performance Tuning Demo Session
 
44:46
More Oracle DBA Courses: https://oraclegenesis.com/ Online trainings: https://oraclegenesis.com/video-courses/ Fly me a trainer: https://oraclegenesis.com/fly-me-a-trainer/ DBA Knowledgebase: https://oraclegenesis.com/dba-knowledgebase/ ORACLEGENESIS provides all you need to build and manage effective Oracle technology learning. We designed ORACLEGENESIS as a simple to use yet powerful online Oracle learning system for students. Each of our courses is taught by an expert instructor, and every course is available on demand.
Views: 85376 DBA Genesis
Oracle || Oracle Session-5 by Dinesh
 
36:10
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 DBA Justin - How to set the current session's schema.
 
15:38
How to set the current session's schema
Views: 2665 jbleistein11
Oracle Financials Training  | 2nd Session  | New Batch Started
 
01:39:02
Oracle Financials Training, Oracle R12 Finance Training, Oracle R12 Financials Functional Training Contact us: US Number: +1 646 491-6833, India Numbers: +91-88860 96632, 96661 83940, Mail: [email protected]
Oracle Enterprise Manager 12c: Use Active Session History (ASH) Analytics
 
03:33
This demonstration shows you how to monitor your database using Active Session History (ASH) Analytics in Oracle Enterprise Manager Cloud Control 12c. Copyright © 2012 Oracle and/or its affiliates. Oracle® is a registered trademark of Oracle and/or its affiliates. All rights reserved. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the "Materials"). The Materials are provided "as is" without any warranty of any kind, either express or implied, including without limitation warranties of merchantability, fitness for a particular purpose, and non-infringement.
Oracle Identity Manager Training -- Session 1
 
01:08:34
Hello Guys, I have started my training classes on Oracle Identity Manager. If anyone wants to join can ping me or call me on my whatsapp no +91-9046881874. Please find the course details below:- Course Overview:- The course "Learn Oracle Identity Manager" is designed for students with little or no background in Oracle Identity Manager. The course start with very basic and then gradually move on to the very advanced topic in Oracle Identity Manager. Course Content:- Module 1:- Overview of Oracle Identity Manager  Overview of Oracle Identity Manager  Consoles in Oracle Identity Manager Module 2:- Starting and Stopping the Service  WebLogic Start/Stop  OIM Start/Stop  SOA Start/Stop  BI Publisher Start/Stop Module 3:- Provisioning and Reconciliation  Provisioning  Reconciliation  Types of Reconciliation  Managing Reconciliation Events Module 4:- Managing Forms  Creating  Searching  Modifying Module 5:- Application Instances  Application Instance Concept  Managing Application Instances  Configuring Application Instances  Developing Entitlements Module 6:- Lookup  Creating  Searching  Modifying Module 7:- Access Policies  Creating Access Policy  Managing Access Policy  Provisioning Multiple Instances of the same resource.  Troubleshooting issues with Evaluate User Policy Job Module 8:- Approval Policies  Understanding Workflow rules  Configuring Approval Workflow rules Module 9:- Disconnected Applications  Disconnected Application Architecture  Managing Disconnected Application instance  Provisioning Operation on a Disconnected Application  Managing Entitlement Module 10:- Connectors  Connector Life Cycle  Installation  Cloning a Connector Module 11:- Understanding OOTB Schedulers  Architecture about ENT List and ENT Assignment  Catalog Sync  Evaluate User Policy  Sun set and Sun rise Module 12:- Understanding Database tables  Request Related tables  Entitlement Related tables  Application instance Related tables  User Related tables  Approval and access policy related tables  Workflow related tables  Provisioning and Reconciliation related tables Advanced Topics 1. OIM and LDAP Integration 2. OIM and UNIX Server Integration 3. OIM and Database Server Integration 4. Adding Custom Attributes in OIM 5. UI Customization Basics 6. OIM API Basics For sample videos do reach on my YouTube channel. For more info do reach me on WhatsApp +91-9046881874 or write me on [email protected] or [email protected]
Views: 11072 Amit Kumar Gupta
Oracle R12 Financials Training | 15th Session | Multi Org & Responsibilities Creation
 
01:22:10
Oracle R12 Financials Online Training for Beginners: 120 Hours Classes, Contact us: India Numbers: +91-88860 96632, 96661 83940 Mail: [email protected], Web: WWW.ERPTREE.COM
Oracle Financials Training | 3rd Session | New Batch Started
 
01:16:29
Oracle Financials Training, Oracle R12 Finance Training, Oracle R12 Financials Functional Training Contact us: US Number: +1 646 491-6833, India Numbers: +91-88860 96632, 96661 83940, Mail: [email protected]
oracle apex course session 1 part 1
 
01:21:41
intro to Oracle apex GUI
Views: 3902 ali saleh ali
Session Room 1 Live Stream: Oracle Code Rome
 
07:38:06
https://developer.oracle.com/code/rome-april-2019
Views: 470 Oracle Developers
Oracle / Acme Packet  Session Border Controller Simplified Configuration Part II: Layers 1-3
 
19:31
In this tutorial, we will first get a little familiar with the CLI and then look at layer 1 to 3 configuration items according to the 7 layer OSI model. If you have any questions/ comments please use the comments section below. For tutorial suggestions/requests, please send us the details by using the contact section of our website, http://www.SIPtopia.org
Views: 7076 SIPtopia.org
Oracle tracing per session
 
07:04
Support demonstrates how to set up an Oracle trace for a particular Desktop Client session To learn more about --- visit: https://www.microfocus.com/ SUBSCRIBE: https://www.youtube.com/channel/UCZHLAuzLykBK09uEJesc2og?sub_confirmation=1 More Micro Focus Links: HOME: https://www.microfocus.com PRODUCTS & SOLUTIONS: https://www.microfocus.com/products SUPPORT & SERVICES: https://www.microfocus.com/support-and-services COMMUNITY: https://www.microfocus.com/communities Micro Focus is a global software company with 40 years of experience in delivering and supporting enterprise software solutions that help customers innovate faster with lower risk.
Oracle Fusion Cloud SCM Training | 3rd Session
 
01:36:42
Oracle Fusion SCM Training, Oracle Fusion Cloud Supply Chain Management, Contact us: USA Number: +1 646 491-6833, India Numbers: +91-88860 96632, 96661 83940 http://www.erptree.com/ Mail: [email protected]
Oracle Financials Training | 8th Session | New Batch Started
 
01:40:30
Oracle Financials Training, Oracle R12 Finance Training, Oracle R12 Financials Functional Training Contact us: US Number: +1 646 491-6833, India Numbers: +91-88860 96632, 96661 83940, Mail: [email protected]
Oracle Locks Part2  Killing a User Session
 
12:46
Oracle Locks Part 2- Killing a User session- Neway IT Solutions
Session-Private Statistics for Global Temporary Tables (GTTs) in Oracle 12c
 
02:18
This video the session-private statistics functionality for Global Temporary Tables (GTTs) in Oracle 12c. For more information see: https://oracle-base.com/articles/12c/session-private-statistics-for-global-temporary-tables-12cr1 Website: https://oracle-base.com Blog: https://oracle-base.com/blog Twitter: https://twitter.com/oraclebase Cameo by Enrique Aviles Twitter: https://twitter.com/eaviles94 Cameo appearances are for fun, not an endorsement of the content of this video.
Views: 838 ORACLE-BASE.com
Oracle Online Training Demo Session 2 | Oracle Online Training
 
45:31
Oracle Online Training Our Online Training Features: 1. Training with Real-Time Experts 2. Industry Specific Scenario’s 3. Flexible Timings 4. Soft Copy of Material 5. Share Video's of each and every session. For Registration : https://goo.gl/r6kJbB For more updates on courses and tips follow us on: Facebook: https://www.facebook.com/NareshIT Twitter: https://twitter.com/nareshitech Google+: https://plus.google.com/+NareshIT For Registration : https://goo.gl/r6kJbB Call: India- 8179191999, USA- 404-232-9879 Email: [email protected]
Views: 1855 Naresh i Technologies
Oracle Fusion Financials Training | User Creation | 3rd Session
 
02:06:08
Oracle Fusion Financials Training, Buy Recorded Class Videos and Attend Live Classes for Free, Contact us: +91-88860 96632, 96661 83940, http://www.erptree.com/ Mail: [email protected]
Oracle R12 Project Accounting (PA) Training | 2nd Session
 
01:24:48
Oracle Project Accounting Training, Contact us: US Number: +1 646 491-6833, India Numbers: +91-88860 96632, 96661 83940 http://www.erptree.com/ Mail: [email protected]
Oracle 11G SQL Session 1 Introduction to Oracle SQL
 
28:02
Oracle 11G SQL Session 1 Introduction to Oracle SQL. To Learn or Teach Linux visit www.theskillpedia.com, A Marketplace for Learners and Trainers. Oracle 11G SQL: Session 1 Introduction Oracle Database 11g: Focus Areas Relational and Object Relational Database Management Systems Data Storage on Different Media Definition of a Relational Database Data Models Relating Multiple Tables Each row of data in a table is uniquely identified by a primary key. You can logically relate data from multiple tables using foreign keys. Relational Database Terminology Using SQL to Query Your Database SQL Statements SELECT INSERT UPDATE DELETE MERGE CREATE ALTER DROP RENAME TRUNCATE COMMENT GRANT REVOKE COMMIT ROLLBACK SAVEPOINT Development Environments for SQL There are two development environments for this course: The primary tool is Oracle SQL Developer. SQL*Plus command-line interface can also be used. Human Resources (HR) Schema Tables Used in the Course Thank You Visit www.theskillpedia.com to Learn or Teach a Skill
Views: 1415 TheSkillPedia
Session 3 Oracle Goldengate DML Replication
 
55:12
Oracle Goldengate Training_DML Replication
Views: 8810 Ashish Agarwal
Oracle SQL Tutorial For Beginners | Oracle SQL Online Training - Session 1
 
52:39
Course : Oracle SQL Online Training Mode of Training : Online Duration : 40 Hours Timings : Flexible Oracle SQL Online Training Demo Registration Link : http://svsoftsolutions.com/demo.aspx Introduction to SQL What is SQL? What Can SQL do? RDBMS SQL Syntax Database Tables SQL Statements Overview of Most Important SQL Commands SELECT UPDATE DELETE INSERT CREATE TABLE ALTER TABLE DROP TABLE CREATE INDEX DROP INDEX SQL SELECT Statement SELECT syntax Demo Database SELECT Column Example SELECT * Example SQL Distinct SELECT DISTINCT Statement SELECT DISTINCT Syntax SELECT DISTINCT Example SQL WHERE Clause WHERE Clause WHERE Clause Example Operators in the WHERE Clause SQL AND & OR Operators AND Operator Example OR Operator Example Combining AND & OR SQL ORDER BY ORDER BY Syntax ORDER BY Example ORDER BY DESC Example ORDER BY Several Column Examples SQL Insert Into INSERT INTO Syntax INSERT INTO Examples Insert Data into Specified Columns SQL UPDATE UPDATE Syntax UPDATE Example Watch out UPDATE statement. SQL DELETE DELETE Syntax DELETE Examples Delete All the Data SQL Aliases SQL Alias Syntax for Columns Alias Example for Table Columns Alias Example for Tables. SQL Joins Different SQL JOINs INNER JOIN LEFT OUTER JOIN RIGHT OUTER JOIN FULL OUTER JOIN SQL UNION UNION Syntax UNION Example UNION ALL Syntax UNION ALL Example SQL Insert Into Select INSERT INTO SELECT Syntax INSERT INTO SELECT Examples SQL Create Table CREATE TABLE Syntax CREATE TABLE Example SQL Constraints CREATE TABLE + CONSTRAINT Syntax NOT NULL Constraint UNIQUE Constraint UNIQUE Constraint on CREATE TABLE UNIQUE Constraint on ALTER TABLE To DROP a UNIQUE Constraint PRIMARY KEY Constraint PRIMARY KEY Constraint on CREATE TABLE PRIMARY KEY Constraint on ALTER TABLE To DROP a PRIMARY KEY Constraint FOREIGN KEY Constraint FOREIGN KEY Constraint on CREATE TABLE FOREIGN KEY Constraint on ALTER TABLE To DROP a FOREIGN KEY Constraint CHECK Constraint CHECK Constraint on CREATE TABLE CHECK Constraint on ALTER TABLE To DROP a CHECK Constraint DEFAULT Constraint on CREATE TABLE DEFAULT Constraint on ALTER TABLE To DROP a DEFAULT Constraint SQL Create Index CREATE INDEX Syntax CREATE UNIQUE INDEX Syntax CREATE INDEX Example SQL DROP Command The DROP INDEX Statement The DROP TABLE Statement The DROP DATABASE Statement The TRUNCATE TABLE Statement SQL ALTER Command The ALTER TABLE Statement ALTER TABLE Example Change Data Type Example DROP COLUMN Example SQL VIEWS CREATE VIEW Statement CREATE VIEW Syntax CREATE VIEW Examples CREATE OR REPLACE VIEW Syntax Dropping a View SQL NULL Values Working with NULL Values IS NULL IS NOT NULL SQL NULL Functions NVL COALESCE For more details visit our website : www.svsoftsolutions.com Or reach us @ USA : +1-845-915-8712 (Toll Free), India : +91-9642373173
Views: 2804 SV Soft Solutions
Find Blocking Session and Release Immediately in Oracle
 
00:16
Find Blocking Session and Release Immediately in Oracle
Views: 336 Sendi Channel
Oracle ERP Demo Session
 
48:17
Oracle ERP Demo Session
Views: 15297 Lead Technologies
Filter - ODI - Oracle Data Integrator Tutorial - Session - 8
 
11:45
In this video you will learn about Filter in ODI
Views: 4525 Trending Courses
Oracle Fusion Cloud HCM Training | 4th Session
 
01:16:18
Oracle Fusion HCM Online Training at ERPTREE.COM Contact us: India Numbers: +91-88860 96632, 96661 83940, Mail: [email protected], Web: WWW.ERPTREE.COM
Oracle 12c PL/SQL Security New Features - Session 6 of 8 - Granting Roles to Procedures
 
06:37
See www.skillbuilders.com/12c-plsql-security for all free modules in this tutorial. It is now in Oracle Database 12c possible to grant roles to the stored program units. Remember this didn't apply to anonymous PL/SQL. Anonymous PL/SQL as always executed with the enabled roles of the invoker. But we can now grant role to a stored procedure. There are a couple of conditions. The role granted must be directly granted to the owner. I'm not sure if this is documented or not or it could've been issues I had during my own testing but certainly the last time I tested this thoroughly I found that if I granted roles to roles to roles to roles as I go down to three, it no longer functions. So that could've been just me or it may be documented. But certainly to be sure, the role granted must be granted directly to the person who's writing the code. Also and it is documented, the owner still needs direct privileges on the object that the code references. That make perfect sense because the role might be disabled at the time that he happens to be creating the object. So you need the role, you need direct privileges on the object referenced by the code. [pause] The invoker however needs absolutely nothing. The invoker now needs nothing, no roles, no privileges. All he needs is execute on the procedure. The invoker will then take on that role during the course of the call. This will tighten up the definer's rights problem and that our user doesn't have much at all. He needs the bare minimum and then only that role will be available, only the role is available to the invoker during the call. Not everything else that the owner happens to have. You can combine this as well with invoker's rights and either way we are controlling privilege inheritance. Invoker's rights plus roles restrict the ability of definer's to inherit privileges from invokers and invokers inherits privileges from definers, both of which raise that ghastly possibility of privilege escalation associated typically to SQL injection. [pause] Grant create session, create procedure to dev, and that will give him select on scott.emp to dev. I've given dev the minimum he needs to write code that hits that table. Then create a role. [pause] Create role r1 and that'll grant select on scott.emp to r1. Finally, grant r1 to dev. It has met the requirements. The role is granted to the owner, the owner does have direct privileges. [pause] So connect as dev/dev and create my favorite procedure. [pause] The same procedure has executed definer's rights and query scott.emp. But now what we can do this new is I can grant r1 to procedure list_emp. [pause] I'll create a very low privileged user now. I need to connect as sysdba and create user low identified by low, and all I shall give him is create session. [pause] And execute on that procedure. [pause] Grant execute on dev.list_emp to low. That's all he's got. He can log on and he can run, run one procedure. What actually is going to happen to him? Let me try to log on. Connect sys low/low set server output on and see if he can run that thing. Just to check, if he tries to select star from scott.emp he is the lowest of the low is my user low. But then execute dev.list_emp, trying to retrieve the CLARKs and it works. And because my user low has virtually no privileges at all, there's no possible danger of the malicious developer being able to inherit dangerous privileges from him. [pause] The final step, that functioned because of the privilege that I mentioned earlier - the privilege that we saw on the previous slide which was inheriting privileges. If I revoke that - and this is what you should be doing in all your systems after upgrade - revoke inherit privileges on user low from public, connect there, and it fails. So the final bit of tightening up the security is to grant the privilege specifically we grant inherit privileges on user low to dev. Now we have a totally secure system and that my low privilege user dev can do that. [pause] And nothing more. My low privileged developer dev can't grab anything in his too as well. That tightens things up totally.
Views: 2887 SkillBuilders
Oracle Fusion Cloud SCM Training | 4th Session | Implementation User Creation
 
01:24:28
Oracle Fusion Cloud SCM (Supply Chain Management) Online Training,Contact us: India Numbers: +91-88860 96632, 96661 83940 http://www.erptree.com/ Mail: [email protected]
Oracle Fusion Cloud Financials Training | 2nd Session
 
01:23:55
Oracle Fusion Cloud Financials Online Classes from ERPTREE.COM Contact us: USA Number: +1 646 491-6833, India Numbers: +91-88860 96632, 96661 83940 http://www.erptree.com/ Mail: [email protected]

Here!
Is online dating socially acceptable
Popular music from vittula online dating
Here!
Here!