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 Chris
Looking for pain-free PeopleSoft web services? 😀
PeopleSoft Simple Web Services (SWS)

Introducing a small but powerful PeopleSoft bolt-on that makes web services very easy. If you have a SQL statement, you can turn that into a web service in PeopleSoft in a few minutes.

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.