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.It's always good to mention forms and DB version.
then, i connect my (module/form) by fatima user and enter the record the data block chart_acc without define schema name "shifa".
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
then create public synonym like
sys/sys@dbname as sysdba;
Now create form base on shifa.chart_acc.
create public synonym chart_acc for shifa.chart_acc;