Home
Search results “Grant proxy user oracle”
Oracle DBA Justin - How to create a proxy user
 
11:59
How to create a proxy user
Views: 3997 jbleistein11
Using the Proxy Connect Feature in Oracle Database
 
02:16
Oracle ACE Dietmar Aust (Opal Consulting) shares technical insight about how ways you can use the proxy connect feature in Oracle Database. This 2 Minute Tech Tip was recorded at ODTUG Kscope 2018 at Walt Disney World in Orlando, Florida. https://developer.oracle.com/ https://cloud.oracle.com/en_US/tryit
Views: 159 Oracle Developers
USER MANAGEMENT HOW TO CREATE  GRANT REVOKE PROXY USER
 
07:43
USER MANAGEMENT-HOW TO CREATE PROXY USER GRANT/REVOKE PROXY =========================================================== proxy user is a user that is allowed to "connect on behalf of another user" create user proxy1 identified by proxy1; create user proxy2 identified by proxy2; grant connect to proxy1,proxy2;(only create session privilege) alter user naveen grant connect through proxy1, proxy2; alter user proxy1 grant connect through proxy2; alter user naveen revoke connect through proxy1,proxy2; alter user proxy1 revoke connect through proxy2; conn proxy1[naveen]/proxy1 conn proxy2[naveen]/proxy2 conn proxy2[proxy1]/proxy2 set lines 180 pages 200 col a20 for proxy select * from proxy_users; (proxy_users -- data dictionary view) select sys_context('USERENV','PROXY_USER') from dual;
Views: 319 Praveen Biyyapu
Did You Know...You Can Grant Proxy Access To Your Oracle Primavera Unifier Account?
 
01:59
Watch some of what the 4C Team can do for you and your business with this selection from our Did You Know…? video series - "Did You Know...You Can Grant Proxy Access To Your Oracle Primavera Unifier Account?". Visit http://www.4cteam.com/did-you-know to view the complete Did You Know…? video series. With more than 100 combined years of Unifier experience, no one is more adept or better prepared than Foresee Consulting to help organizations learn about Oracle Primavera Unifier and how to use it. Looking for more? Explore the full list of our Unifier training courses at http://www.4cteam.com/training to see how the 4C Team can help you understand and maximize the benefits of Primavera’s industry-leading program and project portfolio management solutions. Facebook: https://www.facebook.com/ForeseeConsulting Twitter: https://twitter.com/4CTeam LinkedIn: https://www.linkedin.com/company/foreseeconsulting Google+: https://plus.google.com/+4cteam YouTube: https://www.youtube.com/user/ForeseeConsulting Website: http://www.4cteam.com/
Proxy User on Oracle R12.2.4 - Oracle E.Business Suite (EBS R12 2 4) Videos
 
07:40
http://www.itconvergence.com - This video covers about This video will present you how to use the Proxy User on the new E-Business Suite release 12.2.4..This videos is about: Oracle EBS 12.2.4, Oracle E-Business Suite New Release 12.2.4, Using Proxy User on Oracle R12.2.4, Oracle 12.2.4, Oracle R12.2.4www.itconvergence.com This video will present you how to use the Proxy User on the new E-Business Suite release 12.2.4.
Views: 1316 IT Convergence, Inc.
Oracle DBA Justin - How to use the restrict access option in an ASM instance
 
10:20
How to use the restrict access option in an ASM instance
Views: 1573 jbleistein11
Oracle Proxy Authentification with Secure Password Store - Demo5
 
04:54
How to connect to Oracle database using a combination of Oracle Proxy Authentification with Secure Password Store. This is Demo5 from the dadbm.com presentation http://www.slideshare.net/KirillLoifman/from-my-pc-to-oracle-remote-database http://www.dadbm.com
Views: 237 DaDBm
Oracle DBA Justin - How to set the Oracle environment on a Unix or Linux system
 
28:22
How to set the Oracle environment on a Unix or Linux system
Views: 51354 jbleistein11
Oracle DBA Justin - How to disable and enable a VPD policy
 
07:36
How to disable and enable a VPD policy
Views: 2574 jbleistein11
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: 16415 jbleistein11
Oracle DBA Justin - How to drop a job from the internal DBMS scheduler
 
06:41
How to drop a job from the internal DBMS scheduler
Views: 2555 jbleistein11
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.
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: 1454 jbleistein11
Oracle DBA Justin - How to disable and re-enable an Oracle database trigger
 
08:27
How to disable and re-enable an Oracle database trigge
Views: 1699 jbleistein11
Oracle DBA Justin - How to determine which databases are currently connected to an ASM instance
 
11:51
How to determine which databases are currently connected to an ASM instance
Views: 4243 jbleistein11
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: 2611 jbleistein11
How to grant execute permissions on a SQL Server Database?
 
12:47
Please subscribe to this channel to get updates.. In this video, you will 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 other videos, How to quickly register multiple SQL Server into SQL Server Management Studio? https://www.youtube.com/watch?v=ApXXS4blbVw How to create Conflicts in Replication in SQL Server? https://youtu.be/nGuUPyla1Cw
Views: 18404 Srikanth Srikanth
Oracle DBA Justin - How to drop/delete an Oracle database
 
09:03
How to delete/drop an Oracle database
Views: 15637 jbleistein11
Oracle DBA Justin - How to change the DBID of an Oracle database
 
20:51
How to change the DBID of an Oracle database
Views: 3888 jbleistein11
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: 5341 jbleistein11
Oracle DBA Justin - How to code a pause/sleep in a PL/SQL script
 
13:52
Oracle DBA Justin - How to code a pause/sleep in a PL/SQL script
Views: 2986 jbleistein11
Oracle DBA Queries   Database status, uptime , SIZE OF DATABASE
 
02:50
oracle dba queries Startup time How large is the database Distribution of objects and data Which sachems are taking up all of the space Show the ten largest objects in the database
Views: 1866 Praveen Biyyapu
Oracle DBA Justin - How to create a basic VPD policy
 
14:13
How to create a basic VPD policy
Views: 6327 jbleistein11
Oracle DBA Justin - How to modify where RMAN backuppieces are written on disk
 
09:29
How to modify where RMAN backuppieces are written on disk
Views: 3368 jbleistein11
USER MANAGEMENT CREATE USER DROP USER   CASCADE
 
07:46
USER MANAGEMENT HOW TO CREATE A USER ===================== create user naveen identified by naveen; create user pavan identified by pavan default tablespace king; HOW TO DROP USER ================= drop user naveen; (it will work if no objects) drop user pavan cascade; HOW TO GRANT ORACLE PREDEFINED ROLES TO USER ============================================ grant connect,resource to naveen; select * from session_privs; set lines 180 pages 200 col username for a30 select username,default_tablespace,temporary_tablespace from dba_users where username like '&user';
Views: 462 Praveen Biyyapu
How to Create User Account in SQL Server Tutorial
 
04:15
Today I'm going to show You Can Create Tutorial. It is one best way to secure your database. If you have installed SQL Server You are using Windows Authentication User Account in SQL Server Mode to Connect SQL Server, that's not good work. Because many friends or any other person they are using your system. They easily delete or change your database from your computer. Basically, more than users using Windows Authentication Mode, I recommend you use Server Authentication Mode to Connect the SQL Server. You just need to create a username, password and authorize role of the database as you like. In this video tutorial, I will teach you How You can make a User to Connect SQL. These few simple steps to create an Account. First of All, you need to Open SQL Server and Connect the SQL Windows Authentication Mode. After that Go to Left Side Right Click to DB Yellow and Green Icon in the Front. After that Select property then select Security Tab and Change the Radio Button Windows Authentication Mode to SQL Server Mode. Then you need to restart the SQL Server and go to right side folder namely Security Right Click it. Then Hover the Mouse New and Login then enter the User Name as you want to use and Select Second Radio Button and enter the password, then you need to uncheck Enforce password expiration. Then Go to Next Tab Server Role and Check Last Option namely sysadmin. Then go to User Map Tab and Select Database as you assign, after that below you can database roles, assign the role as you like. That’s it, However, Kindly Watch the Complete video tutorial for getting more ideas. If you have any question/suggestion kindly comment me. Please Subscriber My YouTube Channel and Share my Video. Thanks, A Lot
Oracle DBA Justin - How to startup an Oracle database
 
24:03
How to startup an Oracle database
Views: 10187 jbleistein11
USER MANAGEMENT HOW TO LOCK UNLOCK EXPIRE USER ACCOUNT IN ORACLE
 
06:51
HOW TO LOCK_UNLOCK_EXPIRE USER ACCOUNT IN ORACLE ================================================= alter user naveen account lock; alter user naveen account lock password expire; alter user naveen account unlock; alter user naveen account unlock password noexpire; alter user naveen identified by newpassword; HOW TO RESET USER PASSWORD TO PREVIOUS EXPIRED PASSWORD (Admin related) ======================================================= select name,password from user$ where name='NAVEEN'; alter user naveen identified by values '&encrypted_values'; HOW TO CHANGE USER PASSWORD FROM USER SIDE ===================================== password
Views: 703 Praveen Biyyapu
Oracle Class34- Controlling User Access
 
20:14
Website: http://javaknowledge.info Source code: http://www.trainingwithliveproject.com FB Page: https://www.facebook.com/javaknowledgeshare FB Group: https://www.facebook.com/groups/PBPTBD
Views: 293 Java Knowledge
HOW TO CHANGE THE SQLPROMPT IN ORACLE
 
02:15
HOW TO CHANGE THE SQLPROMPT =========================== show sqlprompt set sqlprompt _USER'@'_CONNECT_IDENTIFIER
Views: 182 Praveen Biyyapu
Oracle DBA Justin - How to change the name of an Oracle database # 1 of 2
 
16:11
How to change the name of an Oracle database
Views: 10245 jbleistein11
Управление версиями БД приложения с помощью Liquibase
 
01:44:58
Выступление Амира Кадырова, разработчика Oracle в компании «Интегратор ИТ», с докладом на CUSTIS Meetup: Russian Oracle User Group (31 июля 2018, Москва).
Views: 599 CUSTIS
Fix "Could not drop Login as the user is currently logged in Error 15434"
 
01:24
Don't forget to subscribe to our channel. https://www.youtube.com/tricksthatmakesmart https://www.facebook.com/tricksthatmakeyousmart https://www.facebook.com/groups/tricksthatmakeyousmart
TABLESPACE MANAGEMENT CREATE TABLESPACE ALTER DATAFILE
 
03:34
How to check existing tablespace information in database ========================================================= select tablespace_name from dba_tablespaces; How to create a tablespace =============================== create tablespace king datafile 'E:\DATABASE\DATABASE\ORADATA\ORCL\KING01.DBF' size 10m; How to Resize the datafile ========================== alter database datafile 'E:\DATABASE\DATABASE\ORADATA\ORCL\KING01.DBF' resize 20m; Adding a datafile to a tablespace ================================= alter tablespace king add datafile 'E:\DATABASE\DATABASE\ORADATA\ORCL\KING02.DBF' size 10m; How to get the defintion of tablespace ====================================== set head off echo off select 'select dbms_metadata.get_ddl(''TABLESPACE'',''' || tablespace_name || ''') from dual;' from dba_tablespaces;
Views: 1000 Praveen Biyyapu
Simplified DBA-012-What is a SCHEMA in Oracle Database
 
02:32
Before you can create any table in database, you need access and resources in database. Access is allowed to a database user or schema. The term user and schema are used interchangeably. A schema is logical grouping of tables and other objects related to an application. Let say you have two different business applications. One application is used my manufacturing company that connect to database as MFG schema and other is a telecom application that connects to database as TEL schema. You will create two schemas as follows: CREATE USER MFG identified by oracle123 default tablespace users temporary tablespace temp; GRANT connect, resource to MFG; alter user MFG quota unlimited on USERS; CREATE USER TEL identified by oracle123 default tablespace users temporary tablespace temp; GRANT connect, resource to TEL; alter user TEL quota unlimited on USERS; alter user MFG quota unlimited on USERS Connect mfg/oracle123 Create table mfg_data(sno number(1) primary key, sname varchar2(20); Connect tel/oracle123 Create table tel_data(sno number(1) primary key, sname varchar2(20);
How to drop all of the objects in a user's recycling bin in oracle database
 
01:58
How to drop all of the objects in a user's recycling bin ========================================================== purge recyclebin how to check the original name of dropped objects in recyclebin =============================================================== select owner,original_name,type from dba_recyclebin; select original_name,type from recyclebin; how to check view on recyclebin =================================================== select table_name from dict where table_name like '%RECYCLE%';
Views: 295 Praveen Biyyapu
Apigee Edge - 4MV4D - SOAP - REST - Custom Logic
 
04:56
In this 4MV4D video you will see how to convert SOAP web services to REST APIs using Apigee Edge & Add some custom logic to the API Proxy after getting response from Target server using Apigee Edge out of the box policies.
Apigee Edge - 4MV4D - Fault Handling - Error Flows - S17E01
 
04:53
In this 4MV4D, Find out basic concepts of API Fault handling & What happens if error occurs in API due to Apigee API Proxy or Backend Target server that returns an Error. Q&A: https://community.apigee.com
Oracle APEX - How to send SMS from oracle apex to Mobile
 
05:03
Today I read an article on Grant Rolands blog about sending a SMS from Oracle Forms through a Web-Service. I thought it would be nice to have the same in APEX and PL/SQL, too. For example if you have a system failure or get a new order in your shop… Grant is using a Web-Service provided by Esendex, but I’m sure there are others service providers available too. First I thought using the offered Web-Service and create a PL/SQL wrapper for it our use the Web-Service feature of APEX. But I decided to go with the simple POST version which is also offered by them. Because why invoke all the Java stuff when there is also a simple version available. The APEX web-service couldn’t be used, because then you would not be able to call it from PL/SQL. The code is quite straight forward. Get a free account, replace the constant values in the example procedure and you are ready to go! Note: If you have a proxy then you have to uncomment the proxy line. There is also a secure version available which uses HTTPS, but that requires a wallet, … and I just wanted to demonstrate that it works. The error handling of the procedure could also be improved, but hey, it’s just a demonstration. Thanks so much for watching this video If you are the first one in my channel Please subscribe to the channel If you have any comments on this video, then definitely give it in the comment box Facebook page Link: https://www.facebook.com/orclapexbd/ Blog Link: http://orclapexbd.blogspot.com/
Views: 4128 Oracle Apex
Oracle DBA Justin - How to delete a specific database object from the recycle bin.
 
06:11
How to delete a specific database object from the recycle bin.
Views: 1202 jbleistein11
Oracle DBA Justin - How to bypass the recycling bin when dropping database objects
 
06:33
How to bypass the recycling bin when dropping database objects
Views: 1123 jbleistein11
TABLESPACE MANAGEMENT RENAME OR MOVE A DATAFILE
 
04:40
RENAME OR MOVE A DATAFILE (when there is space issue in os level file movement is required) ========================== 1)TABLESPACE SHOULD BE OFFLINE(when we move or rename a datafile users should not access) 2)FROM OS LEVEL DATAFILE COPY TO NEW LOCATION 3)SQL LEVEL RENAME THE DATAFILE TO NEW LOCATION 4)MAKE THE TABLESPACE ONLINE alter tablespace king offline; os level rename king01.dbf TO GOODKING01.dbf os level move the file to new location(KING02.DBF) alter tablespace king rename datafile 'E:\DATABASE\DATABASE\ORADATA\ORCL\KING01.DBF' to 'E:\DATABASE\DATABASE\ORADATA\ORCL\GOODKING01.DBF'; alter tablespace king rename datafile 'E:\DATABASE\DATABASE\ORADATA\ORCL\KING02.DBF' TO 'D:\ORADATA\KING02.DBF'; alter tablespace king online; HOW TO CHECK DATAFILES INFO IN PARTICULAR TABLESPACE ===================================================== COL FILE_NAME FOR A50 COL TABLESPACE_NAME FOR A20 select tablespace_name,file_name from dba_data_files where tablespace_name like '&tablespace_name';
Views: 876 Praveen Biyyapu
How to drop an object, and then recover it from the Oracle recycle bin
 
02:53
How to drop an object, and then recover it from the Oracle recycle bin ========================================================== select base_object from recyclebin; flashback table tablename to before drop; create table ============= create table fish as select * from tab; insert data into table ====================== insert into fish select * from tab; insert into fish select * from fish; drop table =========== drop table fish; how to recover it from recyclebin ================================== flashback table fish to before drop;
Views: 275 Praveen Biyyapu
Adding Role-Based Security and Data Masking to MySQL with Hexatier
 
31:08
Presentation given at the New York City MySQL Meetup, Sept 8 2016. Slides are at; http://www.slideshare.net/ScottUhrick/hexatier-mysql-rolebased-security-data-masking Slides for an upcoming and more complete presentation are at; http://www.slideshare.net/ScottUhrick/adding-rolebased-security-and-data-masking-to-mysql-through-a-hexatier-proxy
Views: 149 Scott Uhrick
MariaDB (like MySQL) - 10 Linux on POWER Killer Apps for AIX People
 
16:29
OK so you know AIX but want to give Linux on POWER a try. MariaDB is one of my top ten and it is very easy to Install - here from the RHEL 7.0 BE install media, Initialise a RDBMS, Start MariaDB, create tables and bulk load tables data. Below is my notes: 1) Very useful information - http://www.if-not-true-then-false.com/2013/install-mariadb-on-fedora-centos-rhel/ 2) yum install mariadb mariadb-server 3) Start now and on reboot systemctl start mariadb.service systemctl enable mariadb.service 4) /usr/bin/mysql_secure_installation It asks for the "root user" password but means the database super user (not Linux root). 5) Access MariaDB: mysql -u root -p 6) Useful to know: show databases ; connect test ; show tables ; source filename-of-SQL-commands ; 7) wget www.tpc.org/tpch/spec/tpch_2_16_1.zip Create teables & big SQL example files dbgen/dss.ddl & dbgen/[1-20].sql 8) Create DB, connect (use) it and add tables: CREATE DATABASE tpch; USE tpch; source /root/tpch_2_16_1/dbgen/dss.ddl ; show tables; 9) Bulk load data from ref_data/1/customer.tbl.1 which is pipe char ended column data LOAD DATA LOCAL INFILE 'customer.tbl.1' INTO TABLE CUSTOMER FIELDS TERMINATED BY '|'; 10) Do the other tables & create indexes then run SQL select * from CUSTOMER; Note uppercase select C_NAME,C_PHONE from CUSTOMER where C_CUSTKEY = '2' ; SELECT * FROM ORDERS,CUSTOMER where CUSTOMER.C_CUSTKEY = ORDERS.O_CUSTKEY; Good luck!
Views: 1790 Nigel Griffiths
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: 320 SkillBuilders
Oracle Workflow 06 Components Directory Service
 
25:44
This Video discusses Directory Service Tables and Views that contain Roles data and Users assigned to these Roles
Views: 522 Tarek Saleh
How to install Oracle 11g Express Edition
 
05:29
**This is for my UOP Class** 1. Download Oracle 2. Extract Oracle 3. Run Oracle Exe 4. Open SQL Command Line -run command "connect system" -Enter password that you created on the installation 5. Once connected create yourself a user "create user username identified by password;" 6. Grant yourself all privileges "grant all privileges to username identified by password;" 7. ALL DONE Now the get started issue use the URL: http://127.0.0.1:8080/apex/f?p=4950:1:1615033681376854 --- Don't forget to Like, Share, Subscribe and Comment!! TWITTER - https://twitter.com/GDevTech FACEBOOK - https://www.facebook.com/GDevTech INSTAGRAM - http://instagram.com/GDevTech SITE - http://gdevtech.reviews/
Views: 3440 Jesus Guzman
Oracle DBA Justin - How to change the name of an Oracle database # 2 of 2
 
07:44
How to change the name of an Oracle database
Views: 3696 jbleistein11