| Given Grants doesn't reflect on Oracle forms 6i [message #579696] |
Thu, 14 March 2013 01:59  |
|
|
Dear All,
good day,Please note yesterday we face one issue regarding grants given on object doesnot reflect on Oracle forms 6i.
When my developer compiled the form the error throws object was not declared which means oracle form not able to access the object which is synonym of other table.Also we recreated the synonym and given grants from table owner and compiled form still throws same error,But i can able to select object from backend command but not from oracle forms.
Also please note the grants reflect in oracle forms after we restart the database,Please advice the reason since i am not strong in PLSQL and forms.
Regards,
Anil
|
|
|
|
|
|
| Re: Given Grants doesn't reflect on Oracle forms 6i [message #579701 is a reply to message #579698] |
Thu, 14 March 2013 02:23  |
|
|
Hi,
Please note we have two schemas MTA_2012 and MTZ_2012_S,the table of MTA_2012.ID_TAB created as synonym in MTZ_2012_S
create synonym mtz_2012_s.id_tab_synonym for mta_2012.ID_TAB
grant all on mta_2012.ID_TAB to mtz_2012_s
Please as per above command we can select table from sqldeveloper by mtz_2012_s.But same when we connect form builder by mtz_2012_s and compile the form is shows mtz_2012_s.id_tab_synonym not declared.give grants doesn't reflect on forms for mtz_2012_s.
Also strangely forms can access mtz_2012_s.id_tab_synonym after we restart database.
Regards,
Anil
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
