Wednesday, August 7, 2019

Database Role JDEADMIN and JDEUSER


Starting with Application JDE 9.2 there comes 2 roles for Database JDEADMIN  and JDEUSER.

During upgrade these roles are not added to database which are migrated from older release.

Run these command


User JDE_DEVELOPMENT

Create role JDEADMIN
Create role JDEUSER
ALTER ROLE JDEADMIN ADD MEMBER JDE

exec sp_MSForEachTable 'GRANT ALTER,REFERENCES, SELECT, INSERT, DELETE, UPDATE ON ? TO [JDEADMIN]'
go

exec sp_MSForEachTable 'GRANT REFERENCES, SELECT, INSERT, DELETE, UPDATE ON ? TO [JDEUSER]'
go