This discussion is archived
3 Replies Latest reply: Feb 2, 2013 7:13 AM by EBSDBA RSS

granting privillages

user3714906 Newbie
Currently Being Moderated
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 Expert
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    pls update
  • 3. Re: granting privillages
    EBSDBA Expert
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points