My Oracle Support Banner

Frequently Asked Questions Concerning ODI Users, Roles Credentials and Security (Doc ID 823783.1)

Last updated on NOVEMBER 08, 2018

Applies to:

Oracle Data Integrator - Version 10.1.3.2.0 and later
Information in this document applies to any platform.

Purpose

We have included in this FAQ document all the known issues and questions regarding Oracle Data Integrator (ODI) Users, Roles Credentials and Security.

Note these are technical issues and questions only, we strongly recommend you go through ODI Documentation User's Guide > Security Manager for a good understanding of of ODI Objects, instances and methods, Generic vs Non-Generic profiles, Users to define your ODI Security according to your needs.

Questions and Answers

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Questions and Answers
 Known Issues    
 Non Supervisor User With Number of Instance Object Privileges Takes Very Long Time to Log In To ODI Studio.
 Non Supervisor User experiences slower ODI Studio performance.
 ODI 10g Issues Fixed in ODI 11g
 Single Sign On
 Configuring ODI External User Authentication
 Problems From Setup/Environment/Usage
 'You are not authorized to View the Object: Object_Name' Error When Login With An ODI User.
 'SNP_USEREXIT' Signaled When Using ODI NG_DESIGNER Profiles In ODI Designer
 "You cannot record your updates" Message When Modifying A User Definition In ODI Security Manager.
 "The user ExecuteScenarioUser is not authorized to perform request OdiStartScen on Agent Internal" Message When Running A Scenario in ODI 11.1.1.5.
 "You are not authorized to Edit the Object: SNP_PSCHEMA" When Executing a Package in ODI 11.1.1.5
 General Questions
 The Two Main Approaches To Security In Oracle Data Integrator
 Assigning Object Instance privileges to an ODI User (or Profile)
 Restricting Privileges To Users And Contexts In ODI With Security Manager.
 How Is It Possible To Inhibit ODI Users From Reverse Engineering Specific Models?
 How Is It Possible To Restrict ODI User Access To Projects and Models?
 How To Set Up An ODI User Who Is Able To View An ODI Project Only?
 Setting Up ODI User Privileges On Folder Objects
  Is it Possible to Grant View And Execute Privileges For Scenario(s) To A User?
 Miscellaneous
 How Do I Update Generic ODI User Profiles In Security Manager When New Versions Have Been Released?
 What Is The Password Of The SUPERVISOR User To ODI?
 Is There A Way Of Bypassing Password Policy In ODI For Specific ODI Users ?
 How To Encrypt a Password Using ODI ?
 How To Reset ODI User Password Using a SQL Editor ?
 Is it Possible To Retrieve The Name Of The Current ODI User in an ODI Variable ?
 How To Inhibit An ODI User From Launching ODI Topology Manager?
 How To Allow An ODI User To Create Project/Models But Not Able To Edit Objects In Topology.
 How To Impede ODI Scenario Developers From Executing Integration Interfaces / Packages / Scenarios In The Production Context?
 How do I setup the Non-SUPERVIOR user to be able to STOP IMMEDIATE without granting them Supervisor Access Privileges?
 How to change ODI SUPERVISOR user's password?
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.