default project

[laugh]

Hello,

is there a way in Oneworld XE to delete a users defaultproject in the OMW?


Günter Felsner
XE, Oracle 8.1.7, SP17.1, update 3, NT-based

[laugh]
I don't think so!
[laugh]
Hey, you never know when you need that Default project.
Kind regards,
Adrian Chimirel
PS As a rule of thumb, the day AFTER you deleted something, is the when you need it, at most. [laugh]

I delete Old User's Default projects through SQL. We are Oracle 8i and our
DBAs runs the delete request for the following.

Table F98220 - System - B7333 (OMW Project Master) for the column named
PMOMWPRJID is = to the default projects name and where PMOMWDESC is = to
Default. We use the two column match just for safety.

I got this information from JDE directly.

Joy Fernandez, JDE CNC & System Administrator
[email protected]

I use SQL to delete them...here is the statement I used and it works great just make sure that you remove all the objects in the projects...and for that I created a version for R98222B

SELECT * FROM sys7333/F98220 WHERE PMOMWPRJID ='USERID' and
PMOMWDESC ='Default'

Delete FROM sys7333/F98220 WHERE PMOMWPRJID ='USERID' and
PMOMWDESC ='Default'

Hope this helps