This content has been marked as final. Show 3 replies
user3714906 wrote:Yes, create synonyms for all those objects in appsxyz schema.
we have created a user appsxyz in production and granted privileges, given to our developers but they are facing problem when ever they want to edit the tables they should keep apps.table_name every where. In test they are using apps user and they can directly give table name. is there any way that we can make appsxyz user as apps without granting full apps user access
Please create synonym for tables in HR schema for example in appsxyz schema in prod.
SQL> conn scott/tiger
SQL> create table test_syn(x varchar2(10));
SQL> grant select on test_syn to apps;
SQL> conn appsxyz/password
SQL> create synonym test_syn for scott.test_syn;
SQL> select * from test_syn;
Like that you have to create synonyms for all the objects which you want to access through appsxyz