How to batch create SSO accounts from Windows or a PL/SQL script
We have just converted our 6i Forms and Reports to 10g (10.1.2.0.2), and run them against a 9i database. In order to be able to securely run reports we set up and configured SSO for a few accounts via the Oracle Identity Management Provisioning Console. We do not have PORTAL – nor do we want it. However, now we need to create about 500 SSO accounts at once. We would prefer to be able to create these accounts in a batch method – eg run something from Windows command line or run a PL/SQL script. We have the DBMS_LDAP package successfully installed in that 9i database. Currently our list of 500 users is simply in a table in the 9i db.
Spent several hours looking through both this site and Metalink, but so far no luck – especially because we don’t have or want PORTAL. If anyone can help, would appreciate it very much.
User dbms_ldap package in the database to use PL SQL to create your database
October 11, 2015
View Thread Other 4 Replies on community.oracle.com
account and then an OID account with a RAD to match the database login. If you
You may have to load the DBMS_Ldap package from the database ADMIN directory first to be available in the database.
LDAP SQL Ex.
user_username := LOWER(new_user) || '@domain.com'; -
retval := dbms_ldap.search_s(my_session, ldap_base,
dbms_ldap.scope_subtree, 'uid=' || user_username, my_attrs, 0,
retval := dbms_ldap.count_entries(my_session, my_message);
my_entry := dbms_ldap.first_entry(my_session,my_message);
my_dn := dbms_ldap.get_dn(my_session,my_entry);
dbpassword := 'PASSWD01';
isvalidrad := forms_rad.newraddefinition(radname,new_user,dbpassword,
sessionestablished := forms_rad.createoidsession(ldap_user, ldap_passwd,
ldap_host, ldap_port, ldap_base);
radcreated := forms_rad.createradforcn(my_dn, 'false', errormessage);
-- Create new user's database account same as RAD account.
v_sql := 'CREATE USER "' || new_user || '" IDENTIFIED BY ' || dbpassword ||
' DEFAULT TABLESPACE JLIM TEMPORARY TABLESPACE TEMP';
EXECUTE IMMEDIATE v_sql;
v_sql := 'GRANT CONNECT TO ' || new_user;
EXECUTE IMMEDIATE v_sql;
We have just converted our 6i Forms and Reports to 10g (10.1.2.0.2), and run them against a 9i database. In order to be able to securely run reports we set up and configured SSO for a few accounts via the Oracle Identity Management Provisioning Conso
I was just wondering if there is any good documentation around about how to use a custom JSP page to register a user in the SSO scheme of things (forgive me if my terminology is not quite correct). Basically, I want any Joe User to be able to come to
How can I create a catalog from a network disk? My program will not open anything on the network.I am not competent in networks, but here is some reading waiting for the experts to help you: http://www.johnrellis.com/psedbtool/photoshop-elements-faq.
the only way to creat an icloud account is with a ipad, iphone or imac. is it possible to creat the account from my windos PC? i already downladed i cloud, and i have an Apple ID but Not an Icloud account/Isa Garduño wrote: the only way to creat an i
i have a demo webservice. it has many operations on proxy service's message flow. How can i create proxy service from demo's wsdl on different domain Edited by: fresh man on Jul 1, 2012 11:17 PMYou can either export the WSDL in a sbconfig.jar and the
How do you create a counter/or increment a number in SQL Developer? for example: x = x + 1; // add 1 to the value of x Thanks,Thank you for your help. In reply to your comment I notice that I forgot the colon ":" when I "DECLARE x = 0;"
I connect to a 10g daabase using SSO through Windows Native Authentication wher the OID user mapps to a single Database user. I need to get the SSO user from pl/sql My fornt end is Portal & FormsHmm, I see. Well your problem boils down to being in th
I am thinking of installing Windows 8 on my Macbook Pro using Boot Camp to create a dual boot system. If I do this, how can I access my current Mac OSX partition from within Windows? Does boot camp mount the Mac OSX partition automatically? If not, h
Using C# 4.0 ODP.NET 11g, vs2010 on Windows XP. Have a procedure that takes two input values and returns 35 PL\SQL Associative Arrays (pl/sql tables). I am currently able to call the proc and have it returned the values. i end up with 35 arrays each
I am currently in IE, but running firefox 25. I like to sync my firefox data. However, the problem is, that I am blind, and cannot create sync account, do the captcha. I am running addon web visum, which is solving captchas for me, however, on creati
apparently i have to type more here to get the ball rolling...? I am new to iTunes. I have loaded a few albums from CD into iTunes, and I can play them & even burn new CDs... But I'd like to do more complex stuff, and the help screens I have read s
How do I create a folder for some emails I receive to be placed on my home screenYou can't have an email folder on your iPad's homescreen, you can only create a folder and access your emails folders within the Mail app (or via Safari or an email app
We are looking for a way to create fillable PDFs that users can enter data into and save (so the PDF needs Reader Rights applied) and we want to be able to automatically create these PDFs from XML files. We are able to do what we want in a manual fas
How do i create an ePub file for ibook on Windows platform?suyog83 wrote: How do i create an ePub file for ibook on Windows platform? Adobe Indesign can do this. I'm sure a simple google search would find various Windows apps. You cannot submit book
Hi, I just got an iPhone 4S, iOS 7. I have Macbook Pro, with OS X 10.9 (Mavericks), iTunes 11.1.1. I have email accounts already set up on my laptop, and I'd like to copy that information to the iPhone, and keep them in sync. I searched for info on
iDVD has disappeared on my new MacBook Pro, so how do I create a DVD with menus and everything?Hi You can not do that - without any DVD authoring software as iDVD. So either • Treat to return Your new Mac (within 14 days) if Apple doesn't give You iD
Cannot create Pop email account from IPhone. Keeps asking if I want to try to create the account without SSL, whether I answer yes or no. I have to create the account via ITunes. Any ideas?No error msg. Just keeps asking over and over again, if I wan
if anyone can help me, please help...Thanks SniperKat but I don't know why for some reason the "NONE" disappeared... I started to create an account and when I saw the credit card thing I just clicked back and back and so I closed the browser...
If I have a main user (admin) account on one Mac, and want to copy its Home Folder over to another Mac that already has user accounts on it, what is the best way to do it? For example, if I boot the source Mac in Target Disk Mode then connect it to t
On my D: drive I've got a folder called MUSIC. Under MUSIC I've got folders by artist and then album. I have no problems putting together playlists from these artists. But I have a few folders that are a combination of many different artists songs. I