Do some of you know how to create a new data group
I would like to know how to create a data group using a new ORACLE ID account (not apps)
I should be able to log on to the application with that new data group
That data group should work exactly has 'Standard' data group
I tried the following:
1.Create the user for the required schema:
2.Grant connect and resource privileges to the user:
3.grant privileges on APPS objects to the user.
4.create synonyms in the user schema for all objects owned by APPS.
I would like to know how to create a data group using a new ORACLE ID account (not apps)
I should be able to log on to the application with that new data group
That data group should work exactly has 'Standard' data group
I tried the following:
1.Create the user for the required schema:
2.Grant connect and resource privileges to the user:
3.grant privileges on APPS objects to the user.
4.create synonyms in the user schema for all objects owned by APPS.
Request and data group
Now let's see the concept of request and data groups. Request group and data group are used while defining a responsibility in Oracle apps.
A request group is attached to a responsibility. It defines the concurrent programs you can execute using the responsibility to which this request group is attached.
The following screenshot shows the data and request group attached to a responsibility:
A request group can be queried; to do this, navigate to System Administrator | Security | Responsibility | Request.