3 Replies Latest reply: Feb 2, 2013 9:13 AM by EBSDBA RSS

    granting privillages

    user3714906
      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
        • 1. Re: granting privillages
          EBSDBA
          user3714906 wrote:
          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
          Yes, create synonyms for all those objects in appsxyz schema.

          Thanks
          • 2. Re: granting privillages
            user3714906
            pls update
            • 3. Re: granting privillages
              EBSDBA
              Hi,

              Please create synonym for tables in HR schema for example in appsxyz schema in prod.

              Ex:

              SQL> conn scott/tiger
              Connected.
              SQL> create table test_syn(x varchar2(10));

              Table created.

              SQL> grant select on test_syn to apps;

              Grant succeeded.

              SQL> conn appsxyz/password
              Connected.

              SQL> create synonym test_syn for scott.test_syn;
              Synonym created.

              SQL> select * from test_syn;


              Like that you have to create synonyms for all the objects which you want to access through appsxyz


              Thanks