Add a custom DB table to OW will different Oracle acct & pswd

Can we add a custom DB table to OW will different Oracle acct & pswd.

All of our DB tables have one specific userid and password.

Can we add a new custom table to the OW system with its own userid and password. If we do this then how do we fix it when the file is accessed by a custom window that we can override the SQL on a headerless detail window so that the window uses a different userid and password to access the data.

How do we give allowed users access to this special table using this new userid and password whenever they go to this custom window. Want the system to work as it has before but because this custom table is of such a confidential nature we want to greatly restrict who has access to this table. Please advise.

It seems the need to interactivly "enter a password" in a JDE form may only make users feel falsely confident, but is no guarantee of anything. Quite the contrary, in most cases, this form data will transmit the password in clear text in many places -- jdenet, HTTP (unless using SSL)...

You may be better off using standard JDE security on the table (including row and column security), or implement different DB proxy user to a datasource with the table, guaranteeing that only the designated JDE users, assigned to the DB proxy, can get accesss.