Home » RDBMS Server » Security » Given Grants doesn't reflect on Oracle forms 6i (10.2.0.5 standard edition Micsoft windows 2008)
Given Grants doesn't reflect on Oracle forms 6i [message #579696] Thu, 14 March 2013 01:59 Go to next message
AnilKampiri
Messages: 69
Registered: September 2012
Location: Chennai
Member

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 #579698 is a reply to message #579696] Thu, 14 March 2013 02:04 Go to previous messageGo to next message
Michel Cadot
Messages: 57611
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Insufficient data to compute.

Regards
Michel
Re: Given Grants doesn't reflect on Oracle forms 6i [message #579701 is a reply to message #579698] Thu, 14 March 2013 02:23 Go to previous message
AnilKampiri
Messages: 69
Registered: September 2012
Location: Chennai
Member

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
Previous Topic: How to rebuild AUD$
Next Topic: Connect as sysdba works, regular credentials don't
Goto Forum:
  


Current Time: Fri Apr 18 19:24:13 CDT 2014

Total time taken to generate the page: 0.09311 seconds