How To Re-Associate An Orphaned SQL User With A SQL Login
I ran across an issue the other day when making a mirror of the Production environment. The problem was that after doing a database backup...
Oracle JDEdwards EnterpriseOne Table Trivia
Deepesh, at JDESource, has a great post about the JDEdwards table property limits. Prior to version 8.9, the maximum number of columns in a table...
How To Disable All Users Not In A Certain EnterpriseOne Role
Below is the SQL that I used to disable all users except those that are in the SYSADMIN role: UPDATE SY910.F98OWSEC SET SCEUSER = '02'...
An EnterpriseOne Scheduler Report You Can Give A User Using SQL
Have you ever had a need to give a user a report of what runs on the scheduler including the UBE name and version, the...