Main Nav

Has anyone ever had to change a third party ID in GOATPAD where you needed  to take away the user ID from one user and assign it to another?  We are in the processes of merging different Banner data sources into our IDM system so each user has one username.  What we have found is that Banner will not let you change an ID of a user.

 

IT Accounts & ITSM Applications Manager

University of New Hampshire

Client Services

Primary: (603) 862-2377

Alternate: (603) 862-4242

Paul.Hodgdon@unh.edu

http://accounts.unh.edu

 

AttachmentSize
image003.jpg1.95 KB

Comments

Message from morgan@orst.edu

On Wed, 24 Jul 2013, Hodgdon, Paul wrote: > Has anyone ever had to change a third party ID in GOATPAD where you > needed to take away the user ID from one user and assign it to another? > We are in the processes of merging different Banner data sources into > our IDM system so each user has one username. What we have found is > that Banner will not let you change an ID of a user. I just tested this with GOATPAD here at OSU, and I was able to change my Third Party ID. In our case though, the Third Party ID is populated from our home-grown IDM processes because the username is generated externally. GOATPAD (actually Oracle) will throw an error if you try to change the Third Party ID to a value that already exists. What error are you getting? Andy
We have scripts that do this at Drake University - we actually use gobtpac_external_user to store the email id so our script updates that column. I think the gorpaud_external_user needs to be removed as well if you are using an ID that was previously used. Angie