This discussion is archived
3 Replies Latest reply: Jan 18, 2013 9:50 PM by HamidHelal RSS

DATA NOT SAVE BY DATA BLLOCK

ASIF NATHANI Newbie
Currently Being Moderated
dear friends,

i m create table chart_acc in "shifa" schema. then i grant connect,resource,select,update,insert,delete privilige to user "fatima" for chart_acc table.
then, i connect my (module/form) by fatima user and enter the record the data block chart_acc without define schema name "shifa".

i hope understand my question.
  • 1. Re: DATA NOT SAVE BY DATA BLLOCK
    HamidHelal Guru
    Currently Being Moderated
    As salamu alikum ASIF NATHANI
    i hope understand my question.
    You have no question just a story.
    i m create table chart_acc in "shifa" schema. then i grant connect,resource,select,update,insert,delete privilige to user "fatima" for chart_acc table.
    then, i connect my (module/form) by fatima user and enter the record the data block chart_acc without define schema name "shifa".
    It's always good to mention forms and DB version.

    Now Question, How you make the data block by connection "fatima" schema ? Or you make the form by connection "shifa" schema and try to run from fatima schema?

    It's always good to create synonym for other schema to use the granted tables and other things...
    In your case make synonym on chartacc_ and make it public and try from fatima.


    Hope this all solved your problems


    Hamid


    If someone's response is helpful or correct, please mark it accordingly.*
  • 2. Re: DATA NOT SAVE BY DATA BLLOCK
    ASIF NATHANI Newbie
    Currently Being Moderated
    hamid thanks for the reply. i m create synonyms but its not working at runtime, data not save whenever i'm not define schema name with datablock (i-e shifa.chart_acc) in property "QUERY DATA SOURCE NAME". i want change the schema name dynamically in base block property, how can i do?
  • 3. Re: DATA NOT SAVE BY DATA BLLOCK
    HamidHelal Guru
    Currently Being Moderated
    As salamu alikum ASIF NATHANI,
    hamid thanks for the reply. i m create synonyms but its not working at runtime, data not save whenever i'm not define schema name with datablock (i-e shifa.chart_acc) in property "QUERY DATA SOURCE NAME". i want change the schema name dynamically in base block property, how can i do?
    ok. Connect as sysdba like
    sys/sys@dbname as sysdba;
    then create public synonym like
    create public synonym chart_acc for shifa.chart_acc;
    Now create form base on shifa.chart_acc.
    go to block property QUERY DATA SOURCE NAME and remove the schema name.

    You are done..

    I tested it.

    Hope this helps


    Hamid

    If someone's response is helpful or correct, please mark it accordingly.*

Legend

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