How to batch create SSO accounts from Windows or a PL/SQL script

Advertisement

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.
Thanks

Advertisement

User dbms_ldap package in the database to use PL SQL to create your database
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,
my_message);
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,
dbtnsnames,errormessage);
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;

October 11, 2015

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 Conso

Create SSO Account from Java/JSP ?

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 do I create a catalog from a network disk?

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.

HT204053 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/

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

How can i create proxy service from another proxy on different domain

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?

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;"

How to get the SSO user from PL/SQL with Windows native authen

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

HT5628 How do I read OSX partition from Windows?

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

How do u create a datatable from PLSQL Associative Arrays returned from SP

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

How can I create sync account, without sync option?

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

How do i create a playlist from an album?

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 from my email to my home screen

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

How to automatically create fillable PDFs from XML

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

HT4168 how do we create epub file on windows platform

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

How do I sync mail accounts from my laptop to iPhone?

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

How do I create a DVD from iMovie with menus? What iDVD use to do!

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

IPhone 3G Cannot create mail account from IPhone.

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

I want to create an Itunes store account but I can't because it asks me the number of my credit card and I don't have one. I saw already people who created accounts without a credit card, how can I create an account without a credit card ?

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...

How to copy a user account from one Mac to another

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

How can I create a playlist from all songs in a single folder

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