Similar User as APPS

[latifa]

Hi Erman,

Customer wants  to access to servers to install packages him self, etc ... so he needs apps user. How can we create a similar user to apps for safety of the system ?

Thanks in advance for your help.

Regards,
Latifa

[ErmanArslansOracleBlog]

Why does he need apps user?
This is a custom app schema right? Why is he deploying under the apps schema?

[latifa]

Hi Erman,

As it's a new environment (build, new version of EBS) so he wants to do tranfer data him self  from the old platform (an earlier version of EBS).

so I think it will be create table and modify tables. No much informations

regards,
Latifa

[ErmanArslansOracleBlog]

Why don't you do the following?

1)Determine the list of APPS-related tables that user needs to access. (read or read/write)
2)Create a seperate database user for him/or her and grant that user accordingly..