Home
Search results “Grant all on package oracle”
Adding a User to Oracle - Full Schema Access, But Read only
 
17:04
Hi friends this video will help you in live environment when you need read only access of other schema object procedure , function packages etc.#AddingaUser #FullSchema #oracle Oracle database Unbeatable,Unbreakable Platform..
Views: 1677 Oracle World
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: 22145 jbleistein11
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: 28149 Manish Sharma
How to create new user, assign roles and grant permission in R12 AME
 
22:37
This oracle demo video our Oracle Expert covers the topic- Define/create a new user, assigning roles and responsibilities and to create grants on Oracle EBS R12 AME (Approval Management Engine). Enroll for our complete trainings at: www.apps2fusion.com/packages Also, visit us at : http://apps2fusion.com/ Contact us at: [email protected] or +44-207-193-5456 | +1-650-318-5241 Follow Us On: Facebook: https://www.facebook.com/apps2fusion Twitter: https://twitter.com/apps2fusion LinkedIn: https://www.linkedin.com/company/apps2fusion Youtube: www.youtube.com/c/apps2fusion
Views: 741 apps2fusion
How to grant execute permissions on a SQL Server Database?
 
12:47
Learn how to grant execute permissions on a SQL Server Database. Also, while preparing this video I have experienced multiple issues and fixed them to achieve the task. Hope you like it. Check out my another article on, How to create Conflicts in Replication in SQL Server? https://youtu.be/nGuUPyla1Cw
Views: 15270 Srikanth Srikanth
Oracle DBA Justin - How to re-create a dropped/deleted Oracle supplied PL/SQL package
 
10:03
How to re-create a dropped/deleted Oracle supplied PL/SQL package
Views: 1448 jbleistein11
SQL tutorial 47: How to Grant Object Privileges With Grant Option in Oracle Database
 
07:13
In this SQL Tutorial you will learn How To Grant Object Privilege using Grant Data Control Language (DCL) statement along with GRANT OPTION flag. Third SQL Tutorial in the series of user privileges in oracle database ------------------------------------------------------------------------ ►►►Timeline◄◄◄ 1:06- Query 1- How To grant Basic Object Privilege (i.e.SELECT Object privilege) to a user 3:31- Query 2 - How to Grant Multiple Object Privilege To a user in 4:26- Query 3 - How To grant Object Privilege on Column Level 5:30- Query 4- How To Grant System Privilege WITH GRANT OPTION flag 6:06- WITH ADMIN OPTION demonstration ------------------------------------------------------------------------ Celebrating 1000 subscribers. Thanks a lot guys for all your love and support. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ List of Object Privilege http://bit.ly/list_of_object_privileges Object Privileges Blog http://bit.ly/object_privileges-in-oracle-database Previous Tutorial System Privilege: http://youtu.be/EQzdtKPiErU Introduction to user privilege: http://youtu.be/iQFb86lM1gs ------------------------------------------------------------------------- Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=kb4rc1 -------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the first one to see my videos! -------------------------------------------------------------------------- Amazon Wishlist: http://bit.ly/wishlist-amazon ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider https://www.facebook.com/imthebhardwaj http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ http://rebellionrider.tumblr.com/ http://www.pinterest.com/rebellionrider/ You can also Email me at [email protected] Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 23693 Manish Sharma
Oracle DBA Justin - How to wrap PL/SQL code in an Oracle database
 
15:28
How to wrap PL/SQL code in an Oracle database
Views: 15965 jbleistein11
How to implement VPD in Oracle Database (Part 2)
 
07:28
How to implement VPD (Virtual Private Database) in Oracle Database(9i,10g,11g,12c) Enterprise Edition. PART 2 Video. links: Part 1 https://youtu.be/JVvtvh3cN1I Part 2 https://youtu.be/xLcin_Wgbvs Part 3 https://youtu.be/mE1cSbmEwnQ Now we will conn to sec_adm user : ------------------ CONNECT sec_adm/sec_adm; This table will contain the user access info. CREATE TABLE users (id VARCHAR2(30) NOT NULL, ouser VARCHAR2(30) NOT NULL, first_name VARCHAR2(50) NOT NULL, last_name VARCHAR2(50) NOT NULL); INSERT INTO users VALUES ('HR','USER1','User','One'); INSERT INTO users VALUES ('FINANCE','USER2','User','Two'); COMMIT; conn schemaowner/schemaowner GRANT SELECT, INSERT ON user_data TO user1, user2; Now we will create the context package: ---------------------------------------- CONNECT sec_adm/sec_adm; CREATE CONTEXT SCHEMAOWNER USING context_package; CREATE OR REPLACE PACKAGE context_package AS PROCEDURE set_context; END; / Next we create the context_package body which will actually set the user context. CREATE OR REPLACE PACKAGE BODY context_package IS PROCEDURE set_context IS v_ouser VARCHAR2(30); v_id VARCHAR2(30); BEGIN DBMS_SESSION.set_context('SCHEMAOWNER','SETUP','TRUE'); v_ouser := SYS_CONTEXT('USERENV','SESSION_USER'); BEGIN SELECT id INTO v_id FROM users WHERE ouser = v_ouser; DBMS_SESSION.set_context('SCHEMAOWNER','USER_ID', v_id); EXCEPTION WHEN NO_DATA_FOUND THEN DBMS_SESSION.set_context('SCHEMAOWNER','USER_ID', 0); END; DBMS_SESSION.set_context('SCHEMAOWNER','SETUP','FALSE'); END set_context; END context_package; / SHOW ERRORS Next we make sure that all users have access to the Context_Package. GRANT EXECUTE ON context_package TO schemaowner,user1,user2; Create Login Trigger Next we must create a trigger to fire after the user logs onto the database. CONNECT sec_adm/sec_adm; CREATE OR REPLACE TRIGGER set_security_context AFTER LOGON ON DATABASE BEGIN context_package.set_context; END; / SHOW ERRORS
Views: 275 OracleDBA
73/125 Oracle PLSQL: Dynamic SQL / DBMS_SQL
 
15:42
تعلم اوراكل حتى الاحتراف Learn Oracle PLSQL EXAM 1Z0-144
Views: 713 khaled alkhudari
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: 5510 jbleistein11
How to implement VPD in Oracle Database (Part 3)
 
12:04
How to implement VPD (Virtual Private Database) in Oracle Database(9i,10g,11g,12c) Enterprise Edition. PART 3 Video. Links: Part 1 https://youtu.be/JVvtvh3cN1I Part 2 https://youtu.be/xLcin_Wgbvs Part 3 https://youtu.be/mE1cSbmEwnQ Create Security Policies In order for the context package to have any effect on the users interaction with the database, we need to define a security_package for use with the security policy. This package will tell the database how to treat any interactions with the specified table. CREATE OR REPLACE PACKAGE security_package AS FUNCTION user_data_insert_security(owner VARCHAR2, objname VARCHAR2) RETURN VARCHAR2; FUNCTION user_data_select_security(owner VARCHAR2, objname VARCHAR2) RETURN VARCHAR2; END security_package; / Next we create the security_package body. CREATE OR REPLACE PACKAGE BODY Security_Package IS FUNCTION user_data_select_security(owner VARCHAR2, objname VARCHAR2) RETURN VARCHAR2 IS predicate VARCHAR2(2000); BEGIN predicate := '1=2'; IF (SYS_CONTEXT('USERENV','SESSION_USER') = 'SCHEMAOWNER') THEN predicate := NULL; ELSE predicate := 'USER_ID = SYS_CONTEXT(''SCHEMAOWNER'',''USER_ID'')'; END IF; RETURN predicate; END user_data_select_security; FUNCTION user_data_insert_security(owner VARCHAR2, objname VARCHAR2) RETURN VARCHAR2 IS predicate VARCHAR2(2000); BEGIN predicate := '1=2'; IF (SYS_CONTEXT('USERENV','SESSION_USER') = 'SCHEMAOWNER') THEN predicate := NULL; ELSE predicate := 'USER_ID = SYS_CONTEXT(''SCHEMAOWNER'',''USER_ID'')'; END IF; RETURN Predicate; END user_data_insert_security; END security_package; / SHOW ERRORS Next we make sure that all users have access to the Security_Package. GRANT EXECUTE ON security_package TO schemaowner,user1,user2; Apply Security Policies to Tables The DBMS_RlS package is used to apply the security policay, implemented by security_package, to the the relevant tables. BEGIN DBMS_RLS.add_policy('SCHEMAOWNER', 'USER_DATA', 'USER_DATA_INSERT_POLICY', 'SEC_ADM', 'SECURITY_PACKAGE.USER_DATA_INSERT_SECURITY', 'INSERT', TRUE); DBMS_RLS.add_policy('SCHEMAOWNER', 'USER_DATA', 'USER_DATA_SELECT_POLICY', 'SEC_ADM', 'SECURITY_PACKAGE.USER_DATA_SELECT_SECURITY', 'SELECT'); END; / Test VPD Finally, test that the VPD is working correctly. Now we will do the test CONNECT user1/user1 INSERT INTO schemaowner.user_data (column1, user_id) VALUES ('User 1', 'HR'); INSERT INTO schemaowner.user_data (column1, user_id) VALUES ('User 2', 'FINANCE'); COMMIT; CONNECT user2/user2 INSERT INTO schemaowner.user_data (column1, user_id) VALUES ('User 1', 'HR'); INSERT INTO schemaowner.user_data (column1, user_id) VALUES ('User 2', 'FINANCE'); COMMIT; CONNECT schemaowner/schemaowner SELECT * FROM schemaowner.user_data; Checking the select option: ------------------------ CONNECT user1/user1 SELECT * FROM schemaowner.user_data; CONNECT user2/user2 SELECT * FROM schemaowner.user_data; Thats all for now
Views: 192 OracleDBA
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: 5164 jbleistein11
Object Privileges
 
05:26
#Oracle #ObjectPrivileges
Views: 155 Hemant K Chitale
Oracle 12c Grant Role to PL/SQL Procedures - Lesson 1 of 2
 
03:35
A great new security feature that can - among other things - prevent SQL injection and a multitude of other security vulnerabilities. In 12c you can make your PL/SQL code secure using a declarative technique. Simply grant a role to the PL/SQL code and add AUTHID CURRENT_USER so that Oracle runs the code with the privileges of the invoker - not the developer (invoker rights procedures). Presto! Without code reviews and / or debugging you will have hardened your PL/SQL web application! In this free tutorial from SkillBuilders Director of Oracle Database Services, Oracle Certified Master John Watson will demonstrate the development of a simple PL/SQL web application, demonstrate SQL injection and how to prevent it with this new feature.
Views: 700 SkillBuilders
Oracle DBA Justin - How to drop all of the objects in a user's  recycling bin
 
05:27
How to drop all of the objects in a user's recycling bin
Views: 1045 jbleistein11
Oracle 12c PL/SQL Security Features - Lesson 4 of 8 - Roles and PLSQL
 
06:21
Learn how Roles really work with Oracle PL/SQL and why a privilege granted via a role can't be used in PL/SQL. Demonstrations, examples. See all lessons and many more free Oracle Database tutorials at https://www.skillbuilders.com/free-oracle-database-tutorials John Watson: We have the business of roles - roles and PL/SQL. The point here is that roles are invisible to PL/SQL. When you compile your code, only direct privileges are available. When you run your code, only direct privileges are available. This is for definer's rights, I should say. When you run the code, only direct privileges are available to grant to the definer. In effect, the definer's rights code, all roles are disabled within the stored procedure. And certainly roles are disabled when compiling the code. Functionally, it's equivalent to having issued the command SET ROLE NONE. Why is this? Why is it you can't use your privileges? It's perfectly straightforward. It's a technology limitation. Quickly to see what's going on. If I go in and say - let me connect or create a clear schema. I'll create myself, grant dba to jw identified by jw. I've created a user and given him ridiculously high privileges. Connect.... What can you do? You can do pretty much anything. If he wants to delete from scott.emp, he can do it. Let's roll back, because along with his dba role, he has the ability to pretty much anything to use the data. Now we'll create a procedure. If I create a procedure, create delemp as begin, and in there I delete from scott.emp, end, compilation errors. What are they? Show error. At line 2 table of view doesn't exist. That's line 2 delete from scott.emp. I remember way back in version 7, this cause so much confusion before we realized what was going on. It's quite simple that when we are within the code, as the definer or the invoker, because this is definer's rights code, when we are within the definer's rights code block or indeed when we are compiling a definer's rights code block, the roles are disabled and that's why we cannot see it. But why is this and why do I say it's a technology limitation? It's because roles can be enabled and disabled. They can be enabled or disabled. That makes it logically impossible to consider a role when executing a stored procedure because I might have the role enabled while I compile it, but how do I know that it's going to be enabled when I run it? If I grant execute on the code to a third party, he doesn't have the role at all and that he must not even be logged on. So it becomes a logical impossibility because of the way roles are used because roles are enabled or disabled. You can dynamically switch them on and off. It's a logical impossibility to use role within definer's rights program module. Invoker's rights code, however, is very different. That infuses some interesting issues. Invoker's rights code can use any roles that happen to be enabled for the user at the time that he invokes it in exactly the same way that an anonymous PL/SQL can use any enabled roles. In the security point of view, the definer can in effect grab any roles within his code that the invoker happens to have. Dave: [Question], John, pardon. How do you enable or disable a role? John: Right now there's several techniques. I won't spend too much time demonstrating. The easiest technique will be alter - I can set role none. And that will have disabled all my roles. Now if you look at this, I've got nothing. If I try to run my code and query - let's see. Yes. If I try to delete from scott.emp I can't see it. So I'll set role dba and now of course I can. That's the easiest way. In fact, there are much more [05:07 inaudible] ways to switch roles on and off. We can do it with operating system authentication and I can do it with proxy authentication. We have a persistent session through application server as well as a user when we pass that session out to many of the users that can switch roles on and off. That's the persistent session switch identities. Perhaps, best of all, I can create what I call secure application roles well it protect the role with a package and that can contest any number of issues - environment variables, maybe the time, maybe your IP address, perhaps the program you're using and switch roles on and off accordingly. So there are many ways for controlling roles and you should do it. Blindly granting roles and letting them be enabled all the time is not good security. The end result for this, however, you can get some pretty unexpected results within your code. I've tried to run through in our first half hour some of the issues that we see with PL/SQL in release 11g and earlier. After a short break, we'll move on to the 12c features.
Views: 286 SkillBuilders
How to grant execute permissions on a SQL Server 2017 Database
 
05:57
Don't forget to subscribe to our channel. https://www.youtube.com/tricksthatmakesmart https://www.facebook.com/tricksthatmakeyousmart https://www.facebook.com/groups/tricksthatmakeyousmart
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;
Exercise 3   Create a Database schema and Grant Schema Privileges
 
11:05
In this video tutorial, i am going to show you how to create a Simple HANA Database Schema and Grant access permission to those Schema.
Views: 2173 Arun krishnamoorthy
how to create directory in oracle 12c, 11g
 
02:52
Use the CREATE DIRECTORY statement to create a directory object. A directory object specifies an alias for a directory on the server file system where external binary file LOBs and external table data are located. You can use directory names when referring to BFILEs in your PL/SQL code and OCI calls, rather than hard coding the operating system path name, for management flexibility. All directories are created in a single namespace and are not owned by an individual schema. You can secure access to the BFILEs stored within the directory structure by granting object privileges on the directories to specific users. You must have CREATE ANY DIRECTORY system privilege to create directories. When you create a directory, you are automatically granted the READ and WRITE object privileges on the directory, and you can grant these privileges to other users and roles. The DBA can also grant these privileges to other users and roles. WRITE privileges on a directory are useful in connection with external tables. They let the grantee determine whether the external table agent can write a log file or a bad file to the directory. For file storage, you must also create a corresponding operating system directory, an ASM disk group, or a directory within an ASM disk group. Your system or database administrator must ensure that the operating system directory has the correct read and write permissions for Oracle Database processes. Privileges granted for the directory are created independently of the permissions defined for the operating system directory, and the two may or may not correspond exactly. For example, an error occurs if sample user hr is granted READ privilege on the directory object but the corresponding operating system directory does not have READ permission defined for Oracle Database processes. ---------------------------------------------------------------------------- Default directory is DATA_PUMP_DIR.Below command is to get directory name and directory path. SELECT directory_name, directory_path FROM dba_directories WHERE directory_name='DATA_PUMP_DIR' DIRECTORY_NAME DIRECTORY_PATH --------------- ------------------------------------------------------- DATA_PUMP_DIR /u01/app/mohammad75/product/12.1.0/dbhome_1/rdbms/log/
Views: 2203 Oracle DBA World
What permissions will you grant to a users in SQL Server database, so He or She can truncate table
 
06:00
SQL Server Interview Question "What permissions will you grant to a users in SQL Server database, so He/She can truncate table?" Complete list of SQL Server DBA Interview Questions by Tech Brothers http://sqlage.blogspot.com/search/label/SQL%20SERVER%20DBA%20INTERVIEW%20QUESTIONS
Views: 15762 TechBrothersIT
Oracle PL/SQL Tutorials | PRAGMA EXCEPTION_INIT | Mr.Vaman Deshmukh
 
07:23
Oracle PL/SQL Tutorials | PRAGMA EXCEPTION_INIT | Mr.Vaman Deshmukh ** For Online Training Registration: https://goo.gl/r6kJbB ► Call: +91-8179191999 ► Visit Our Website for Classroom Training: https://nareshit.in ► For Online Training: https://nareshit.com/ #OraclePLSQLTutorials #PRAGMAEXCEPTION_INIT -------------------------- ► About NareshIT: "Naresh IT is having 14+ years of experience in software training industry and the best Software Training Institute for online training, classroom training, weekend training, corporate training of Hadoop, Salesforce, AWS, DevOps, Spark, Data Science, Python, Tableau, RPA ,Java, C#.NET, ASP.NET, Oracle, Testing Tools, Silver light, Linq, SQL Server, Selenium, Android, iPhone, C Language, C++, PHP and Digital Marketing in USA,Hyderabad, Chennai and Vijayawada,Bangalore India which provides online training across all the locations -------------------------- ► 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 Videos of each and every session. -------------------------- Please write back to us at [email protected]/[email protected] or Call us at USA: +1404-232-9879 or India: +918179191999 ** Check The Below Links** ► For Course Reg: https://goo.gl/r6kJbB ► Subscribe to Our Channel: https://goo.gl/q9ozyG ► Circle us on G+: https://plus.google.com/NareshIT ► Like us on Facebook: https://www.facebook.com/NareshIT ► Follow us on Twitter: https://twitter.com/nareshitech ► Follow us on Linkedin: https://in.linkedin.com/company/naresh-i-technologies ► Follow us on Instagram: https://www.instagram.com/nareshitech/ -------------------------------------------------------------------------------------------------------- #oracletutorials #oraclevideos #sqltraining #sqltutorials #oracletraining
How to Grant Permission on Table Columns in MairaDB - MariaDB Admin Tutorial
 
13:11
How to Grant Permission on Table Columns in MairaDB demo explains how you can provide permissions on column level in MariaDB. You will be able to provide Select, update and Insert permission on columns in MariaDB. Link to scripts used in the demo http://techbrotherstutorials.com/pages/tutorials/MariaDB%20Administration%20_126/How%20to%20Grant%20Permission%20on%20Table%20Columns%20in%20MairaDB_1016 Check out our website for Different SQL Server, MSBI tutorials and interview questions such as MariaDB Admin Tutorial Cassandra CSQL Tutorial SQL Server Reporting Services(SSRS) Tutorial SQL Server Integration Services(SSIS) Tutorial SQL Server DBA Tutorial SQL Server / TSQL Tutorial ( Beginner to Advance) http://www.techbrothersit.com/ http://techbrotherstutorials.com/
Views: 249 TechBrothersIT
Oracle SQL PLSQL 12C Tutorial 11 - CREATE table from other table
 
03:06
This Video Tutorial Will Describe how to CREATE TABLE from OTHER TABLE in oracle 12C version. This command will also work on other versions of database like Oracle 11g Database, Oracle 10g Database, Oracle 9i Database, Oracle 8i Database, Oracle 8 Database and so on. Whenever you create a new table in oracle, you need to specify the columns and datatype and length of the table. But sometimes you need to create a table which is exactly same as the other table. you need the same structure as the other table have. So, in that case, you need not write the whole columns etc. This command will help you to do that. Full Syntax will be given in this video tutorial about how to create a table from another table in oracle database. Along with the live example to create the table from another table. All the keywords, format, mandatory clauses etc are described in this video.
SQL Server DBA Tutorial 62-How to Provide View Definition Permission of Database Objects to a user
 
03:48
This video shows step by step process of providing view definition permission of database objects to a user in SQL Server using SQL Server Management studio as well as using T-SQL Script. It covers how to provide view definition permission on tables as well as other database objects such as store procedures etc. Blog post link for this video: http://sqlage.blogspot.com/2015/03/how-to-provide-view-definition.html Visit our website to check out SQL Server DBA Tutorial Step by Step http://www.techbrothersit.com/2014/12/sql-server-dba-tutorial.html
Views: 7635 TechBrothersIT
[오라클 기초 강좌] 19 - Procedure, Function , Package - PL/SQL, Header & Body
 
27:35
강의 자료(PDF) 다운로드: https://goo.gl/VZovDV - PL/SQL은 데이터베이스 내에서 절차적인 처리를 할 수 있도록 지원하는 3GL 언어이다. - Procedure와 Function은 PL/SQL, Java, C 언어 등을 이용하여 작성된다. - Procedure는 실행 결과를 리턴하지 않고 Function은 실행 결과를 리턴한다. - Package는 관련된 Procedure와 Function들의 묶음이다. - Package는 Header 부분과 Body 부분으로 구성되어진다. - Business Logic을 Stored Procedure 내에 두면 Client Application 수정 없이 System을 변경 할 수 있고(유연성 향상), 성능을 향상 시킬 수 있다.
Views: 2254 Yongjin Choi
Webutil configuration in Oracle Forms 11g
 
13:53
Webutil configuration in Oracle Forms 11g install.syslib.0.0.7.1=jacob-1.18-x86.dll|167936|1.18|true install.syslib.0.1.7.1=jacob-1.18-x64.dll|205312|1.18|true CREATE USER Webutil IDENTIFIED BY Webutil; grant create session, create procedure, create public synonym to webutil; Grant connect, resource to Webutil; Connect Webutil/Webutil; @c:\oracle\middleware\oracle_frhome1\forms\create_webutil_db.sql; connect sys as sysdba; Create public synonym webutil_db for webutil.webutil_db; Grant execute on webutil_db to public; [scott] form=E:\TEST\TEST_INFO.fmx userid=scott/[email protected] separateFrame=False WebUtilArchive=frmwebutil.jar,jacob.jar WebUtilLogging=off WebUtilLoggingDetail=normal WebUtilErrorMode=Alert WebUtilDispatchMonitorInterval=5 WebUtilTrustInternal=true WebUtilMaxTransferSize=20000 baseHTMLjinitiator=webutiljpi.htm baseHTMLjpi=webutiljpi.htm archive_jini=frmall_jinit.jar,frmall.jar archive=frmall.jar width=100% height=100% pageTitle=Testing for Scott lookAndFeel=oracle colorScheme=teal
Views: 5466 M Tarik
Grant SQL jobs view access
 
12:20
Grant SQL jobs view access. -- Paresh Bhadekar. Like and Subscribe for more videos :) If you need scripts then please comment will upload the required scripts.
طريقة تصطيب الديزاينر وعمل مشروع مصغر عليه
 
50:30
دي الصلاحيات المطلوبه لليوزر 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: 1205 Ahmed Tartour
Toad for Oracle Schema browser how you will get the detail of database object ,log on schema
 
06:35
Toad for Oracle Schema browser how you will get the detail of database object ,log on schema,others schema,user
Views: 8053 Abinash Sahoo
1  Connecting with oracle and creating new user
 
03:50
The complete package of oracle 10g XE.....
Views: 72 Manoj Mahato
User & Responsibility Details Report in ORACLE APPS R12 | Class 3
 
53:43
This video shows you how to givie responsibility details for an user etc.. in Oracle Applications R12
Oracle DBA Justin - How to create a proxy user
 
11:59
How to create a proxy user
Views: 3876 jbleistein11
Using Virtual Private Database with Oracle Database 12c
 
04:44
This video shows you how to implement a security policy using the application context functionality of Oracle Database 12c. 1. What is FGAC and VPD? 2. Set up for the demo (Create user, application context, package, trigger and grant privileges). 3. Create the package that is used by the security policy to return a predicate. 4. Create a policy and test it. 5. Drop a policy. Recommended after this: * Using VPD Types * Troubleshooting a VPD policy Copyright © 2014 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.
Infosys ssis interview questions
 
11:59
Video talks about Infosys ssis interview questions ssis interview questions Infosys ssis interview questions and answers Wipro ssis interview questions ssis interview questions and answers HCL ssis interview questions and answers Infosys ssis interview questions usa 1. What is SSIS? Is there any alternative tool for this? 2. How do you execute SSIS packages? 3. Have you automated the SSIS package any time? 4. Do you know debugging? 5. What are all the debugging techniques? 6. Can I deploy package in the PROD/UAT with break points? If No.. why? If Yes.. Why? 7. What is Data viewer? 8. Can you explain flow for a simple scenario.. Like load data from Oracle to Excel files.. 9. What is configuration in SSIS? 10. What are parameters in SSIS? 11. What is the difference between parameters and Variables in SSIS? 12. Can you tell one complex scenario in your current project? 13. How do you handle complex scenarios in the project? Step by step SQL Training videos Step by step SSIS Training videos SSIS Tutorial SSRS Tutorial More videos at https://www.youtube.com/channel/UCgWvQ6cBxZwABl_hL48ayXg
Views: 9613 Training2SQL MSBI
Debugging PL/SQL with Oracle SQL Developer
 
02:37
Quick 2 minute video showing how to open a PL/SQL program in Oracle SQL Developer and debug it, line by line.
Views: 35446 Jeff Smith
Oracle DBA Justin - How to exempt a user from a VPD policy
 
07:05
How to exempt a user from a VPD policy
Views: 2283 jbleistein11
EXECUTE IMMEDIATE ORA-01031: insufficient privileges
 
01:34
http://dbacatalog.blogspot.com
Views: 7072 dbacatalog
How to Create User Role in Oracle Transportation Management Cloud  (OTM)
 
04:48
This video will help you to Create user, screen set, assign a manager to the screen set, then asssign it to a Menu & finally assign the menu to a User in Oracle OTM Application. Enroll for our complete trainings at: www.apps2fusion.com/packages Also, visit us at : http://apps2fusion.com/ Contact us at: [email protected] or +44-207-193-5456 | +1-650-318-5241
Views: 662 apps2fusion
Oracle DBA Justin - How to set an Oracle database to readonly # 1 of 2
 
17:13
How to set an Oracle database to readonly
Views: 3388 jbleistein11
Oracle DBA Justin - How to drop/delete Statspack from an Oracle database
 
05:50
How to drop/delete Statspack from an Oracle database
Views: 2916 jbleistein11
Narrative Reporting with Oracle's Enterprise Performance Reporting Cloud Service EPRCS
 
45:40
Stop wasting time sending document versions between people and manually entering financial metrics into your key reports. Oracle's cloud-based Enterprise Performance Reporting solution offers rapid enablement, low IT costs, and immediate value. Transform your annual financial reports, budget books or grant reports by easily combining data with narrative text; tapping into knowledge from across the entire organization through secure collaboration. In this upcoming webinar, AST will provide an overview of the Oracle Enterprise Performance Reporting Cloud Service (EPRCS) and will demonstrate how this solution can modernize your narrative reporting processes and inform your decisions. Research shows that organizations that effectively use narrative reporting benefit from: • Higher levels of strategic planning • Enhanced communication to internal and external stakeholders • Better information to support decision-making Please join us to witness real-world scenarios from organizations that are delivering powerful collaborative narrative reports – all in a safe and secure environment with minimal capital expenditure.
Setup  Database Oracle10g Express , Setup Oracle Developer Suite 10g
 
41:22
Install Oracle Database 10g Express Create User In Oracle Database Grant Permission To User in Oracle Database Install Oracle Developer Suite 10g Install Netscape-Navigator Install Jinit Connection From Oracle Forms Builder To Database EX
Views: 159 Abdullah mohamed
Oracle Create Table , Drop Table تعليم اوراكل
 
14:08
by Mohamed El Desouki - محمد الدسوقى [email protected] Tel :00966 553450836 جامعة سلمان بن عبد العزيز - السعودية - الخرج Create table and Drop Table, إنشاء وحذف الجداول Text Book: Fundamentals of Database Systems, 5th Edition, by Elmasri/Navathe, published by Addison-W oracle create table statement oracle drop table statement
(002) How to Grant sysadmin role/permission/privilege in Microsoft SQL Server
 
01:00
Please subscribe to support our channel. How to Grant sysadmin role/permission/privilege in Microsoft SQL Server Please subscribe to support our channel. Visit our web site https://www.sdk-it.com
Oracle Tutorial - Add Comment on a Table and Column | Remove Comment
 
09:36
Oracle Tutorials: Add Comment on a Table and Column | Remove Comment from a Table and Column
Views: 131 Tech Acad
May 2016 CodeTalk: Securing PL/SQL Code From Attacks
 
31:31
Steven Feuerstein, Oracle Developer Advocate for PL/SQL, and Rob Lockard, database security expert and winner of a 2015 Oracle Database Developer Choice award, discuss the top security issues facing Oracle developers today and how they can harden their applications against attack. ================================= For more information, see http://www.oracle.com/goto/oll Copyright © 2016 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. 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 or merchantability, fitness for a particular purpose, and non-infringement.