peterfourie
Active Member
Hi All,
We recently migrated from DB2 UDB on Windows to Oracle on Windows. The
migration all went went well and everything worked great.
In order to get the Oracle database ready, we ran the standard JDE scripts
to create the database etc, and then copied the data over from DB2 using
R98403.
Anyway, all the users created in Oracle (i.e. Proddta, testdta etc etc.) are
members of PUBLIC and have full db rights (i.e. inseert, update, delete
anywhere in the database). Is this normal, or should a use like Proddta be
restyricted to only the tables within it and not have full rightsa to say
TESTDTA? Are there any best practices oif this should be changed?
Also, we need to change the passwords for proddta, testdta etc. Is this doen
at the Oracle database level and then JDE will just pick it up (e.g. when I
need to gerenrate a table, it will know that I need the new password)? If
not, where can I find the app in JDE to do this?
Any help would be greatly appreciated.
XE SP 19 Update 6
Intel NT, Oracle 9.0i
Peter J Fourie
We recently migrated from DB2 UDB on Windows to Oracle on Windows. The
migration all went went well and everything worked great.
In order to get the Oracle database ready, we ran the standard JDE scripts
to create the database etc, and then copied the data over from DB2 using
R98403.
Anyway, all the users created in Oracle (i.e. Proddta, testdta etc etc.) are
members of PUBLIC and have full db rights (i.e. inseert, update, delete
anywhere in the database). Is this normal, or should a use like Proddta be
restyricted to only the tables within it and not have full rightsa to say
TESTDTA? Are there any best practices oif this should be changed?
Also, we need to change the passwords for proddta, testdta etc. Is this doen
at the Oracle database level and then JDE will just pick it up (e.g. when I
need to gerenrate a table, it will know that I need the new password)? If
not, where can I find the app in JDE to do this?
Any help would be greatly appreciated.
XE SP 19 Update 6
Intel NT, Oracle 9.0i
Peter J Fourie