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: 3957 jbleistein11
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: 311 Praveen Biyyapu
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: 1295 IT Convergence, Inc.
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: 139 Oracle Developers
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/
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: 1572 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: 2586 jbleistein11
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: 50393 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: 445 Praveen Biyyapu
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: 3335 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: 227 DaDBm
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: 694 Praveen Biyyapu
HOW TO CHANGE THE SQLPROMPT IN ORACLE
 
02:15
HOW TO CHANGE THE SQLPROMPT =========================== show sqlprompt set sqlprompt _USER'@'_CONNECT_IDENTIFIER
Views: 179 Praveen Biyyapu
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: 17536 Srikanth Srikanth
Oracle DBA Justin - How to disable and enable a VPD policy
 
07:36
How to disable and enable a VPD policy
Views: 2560 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: 2544 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: 1688 jbleistein11
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: 1453 jbleistein11
Oracle DBA Justin - How to drop/delete an Oracle database
 
09:03
How to delete/drop an Oracle database
Views: 15467 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: 5264 jbleistein11
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);
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: 290 Java Knowledge
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: 10208 jbleistein11
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: 3693 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: 16296 jbleistein11
Oracle DBA Justin - How to create a basic VPD policy
 
14:13
How to create a basic VPD policy
Views: 6247 jbleistein11
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: 3427 Jesus Guzman
Oracle Database 12c: Creating a Unified Audit Policy
 
04:25
Overview and demo of using a unified audit policy to audit database behaviors, database components, and database users. "Monitoring Database Activity with Auditing" in Oracle Database Security Guide: http://www.oracle.com/pls/topic/lookup?ctx=db121&id=CCHEHCGI "Auditing Database Activity" in Oracle Database 2 Day + Security Guide: http://www.oracle.com/pls/topic/lookup?ctx=db121&id=BCGGIAIC "Keeping Your Oracle Database Secure" in Oracle Database Security Guide: http://www.oracle.com/pls/topic/lookup?ctx=db121&id=CHDCEBFA
Views: 2728 OracleDBVision
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: 3681 Oracle Apex
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: 286 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
Atelier Les fichiers de parametre et de contrôle
 
10:18
1)show parameters 3)show parameter spfile 4)show parameter db_block_size 5)show sga 6)select name from v$controlfile; 7)alter database backup controlfile to trace; 8)- Shut down the database - Copy the control file to more locations using operating system command. cp u01/app/oradata/ord/control01.ctl u05/app/oradata/ord/control02.ctl - Change the initialization parameter to include new file in the parameter CONTROL_FILES CONTROL_FILES = 'u02/appl/oradata/ord/control01.ctl', 'u03/appp/oradata/ord/control01.ctl', 'u04/app/oradata/ord/control01.ctl', 'u05/app/oradata/ord/control01.ctl') - Start the instance startup;
Views: 74 Houssine Formation
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: 1802 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.
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: 1198 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: 1121 jbleistein11
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
Associate an Employee to a User
 
01:52
Associate an Employee which is created in HRMS to a Oracle Application User. Check how to create an Employee before starting with this video: http://www.youtube.com/watch?v=mrcw5hwqTHM
Views: 182 abcdefgh1206
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
Oracle DBA Justin - How to change the DBID of an Oracle database
 
20:51
How to change the DBID of an Oracle database
Views: 3875 jbleistein11
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: 269 Praveen Biyyapu
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: 4217 jbleistein11
Linux Configuration
 
18:08
Linux Configuration This tutorial gives you the exact steps Basic Configuration Linux System. This tutorial outlines include all steps below: + Configure Hostname + Configure Network Connections ( IP / Default Gateway / NTP / Static Route ...) + Configure User / Group + Grant Sudo Access for User. + Disk Management More series video at: https://www.youtube.com/channel/UC8UMNdOm4Gx6Z14gn3GgFpw/videos
Views: 1295 IT Training Tutorial
Oracle DBA Justin - How to startup an Oracle database
 
24:03
How to startup an Oracle database
Views: 10099 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: 845 Praveen Biyyapu
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: 508 Tarek Saleh
What happens to transactions when the sqlplus program is closed
 
02:44
What happens to transactions when the sqlplus program is closed =============================================================== create table fruit(sno number); insert into fruit values (1); insert into fruit values (2); select * from fruit; quit; conn naveen/naveen insert into fruit values (3); insert into fruit values (4); select * from fruit; close the cmd promt;
Views: 173 Praveen Biyyapu
McAfee and Skyhigh Security Cloud Integrations
 
05:44
In this video, we will explore the benefits of McAfee Web Gateway’s integration with McAfee Skyhigh Security Cloud (formerly Skyhigh Networks) to consistently enforce cloud-specific usage policies directly from McAfee Web Gateway. McAfee is the device-to-cloud cybersecurity company. Inspired by the power of working together, McAfee creates business and consumer solutions that make our world a safer place. Connect with McAfee: Visit McAfee Website: https://mcafee.ly/2py7484 Follow McAfee on Twitter: https://mcafee.ly/Twitter Follow McAfee on LinkedIn: https://mcafee.ly/LinkedIn Follow McAfee on Facebook: https://mcafee.ly/facebook
Views: 1331 McAfee