Back End Role Insert
By Chris Malek | Tue, Oct 12, 2010
This is a script to show you how to insert a role from the back end.
INSERT INTO
PSROLEUSER (ROLEUSER, ROLENAME, DYNAMIC_SW)
VALUES ('CMALEK','PeopleTools','N')
Note: If you are syncing user profiles with an integration broker this is not a good idea because it will not trigger a service operation message.
Article Categories
Author Info
Chris Malek
Chris Malek is a PeopleTools® Technical Consultant with two decades of experience working on PeopleSoft enterprise software projects. He is available for consulting engagements.
About Chris Work with ChrisPeopleSoft REST APIs in Minutes, Not Months
PeopleSoft Simple Web Services (SWS)
SWS turns SQL into production REST APIs — ready for AI, modern apps, and partner integrations. One install, unlimited potential.
- Configuration-driven, no coding required
- JSON, XML, and CSV output
- Works across all PeopleSoft pillars
- Built on 25+ years of PeopleSoft expertise
Book
Integration Broker - The Missing Manual
I am in the process of writing a book called "Integration Broker - The Missing Manual" that you can read online.