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 integration broker this is not a good idea because it will not trigger a service operation / message.

Article Categories

Security

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
Product
PeopleSoft Simple Web Services (SWS)
Do you need a quick way to create web services?

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.

Read More & Purchase
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.

Read Online