Questions regarding Peoplesoft user profile.

Jenny

Active Member
I am seeing following user profiles in peoplesoft enterprise one 8.10. Most of them are Database users. Will it affect anything if I delete those users from system? Is this users related with any applications? Help will be appreciated. Thanks in advance.

APPLEAD,CRPCTL,CRPDTA,DD810,DEVUSER,DV810,JDE,OL810,PD810,PRISTDTA,PRODCTL,PRODDTA,PRODUSER,PS810,PS810CTL,
PS810DTA,SVM810,SY810,TESTCTL,TESTDTA

Peoplesoft enterprise one 8.10, SQL server
 
Hi Jenny,

You can safely delete the following SQL logins :

APPLEAD, DEVUSER and PRODUSER.

The rest are used by JDE to identify tables by owner.
 
We've removed all of those profiles with no problems so far. The only difference is that we are still on XE. However, that shouldn't matter as the table to owner relationship is defined by OCM and the database data source definition.
 
Back
Top