3 Replies Latest reply: Jan 18, 2013 11:50 PM by HamidHelal RSS

    DATA NOT SAVE BY DATA BLLOCK

    ASIF NATHANI
      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
          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
            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
              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.*