Home » Developer & Programmer » Application Express & MOD_PLSQL » ORA-00942: Table or view does not exist (Application Express, 4.0, windows 7)
ORA-00942: Table or view does not exist [message #533695] Thu, 01 December 2011 02:39 Go to next message
abarnybox
Messages: 49
Registered: November 2011
Member
Hi,

I exported then imported an application from one workspace to another and I am now getting this error when logging in:
ORA-00942: Table or view does not exist
Error ERR-1082 Error in executing authorization scheme code.
anyone know whats wrong? I mean i'm missing a table somewhere obviously but...yeh
It was connected to the company database so anyone in the company could log in with their existing login/password so surely solong as code connecting it is there it should be fine?
If it is something complicated then I won't be able to sort it out and I'll have to ask my boss.

any help appreciated none the less

thanks
abarnybox
Re: ORA-00942: Table or view does not exist [message #533709 is a reply to message #533695] Thu, 01 December 2011 03:12 Go to previous messageGo to next message
abarnybox
Messages: 49
Registered: November 2011
Member
Its ok I sorted it.
Re: ORA-00942: Table or view does not exist [message #533710 is a reply to message #533709] Thu, 01 December 2011 03:14 Go to previous messageGo to next message
Littlefoot
Messages: 19630
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
How?
Re: ORA-00942: Table or view does not exist [message #533725 is a reply to message #533710] Thu, 01 December 2011 03:42 Go to previous messageGo to next message
abarnybox
Messages: 49
Registered: November 2011
Member
the ADMIN authorization scheme had the code
select 'YES' "ACCESS_GRANTED"
from FM_ADMIN
where UPPER(MUID)=UPPER('&APP_USER.')

But in the new workspace the ADMIN table was called MD_ADMIN so I just changed that.
Re: ORA-00942: Table or view does not exist [message #533726 is a reply to message #533725] Thu, 01 December 2011 03:45 Go to previous messageGo to next message
Littlefoot
Messages: 19630
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Changed what exactly? FM_ADMIN.MUID (from 'MD_ADMIN' to 'ADMIN')?
Re: ORA-00942: Table or view does not exist [message #533732 is a reply to message #533726] Thu, 01 December 2011 03:51 Go to previous messageGo to next message
abarnybox
Messages: 49
Registered: November 2011
Member
changed the 'FM_ADMIN' after "from" to 'MD_ADMIN'

the 2 tables are laid out exactly the same they just have different names so I would imagine if you had a different layout to the table or changed the name of the columns you would need to change more things.
Re: ORA-00942: Table or view does not exist [message #533735 is a reply to message #533732] Thu, 01 December 2011 03:56 Go to previous messageGo to next message
Littlefoot
Messages: 19630
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Oh, sorry ... didn't realize that it was a TABLE NAME you changed.
Re: ORA-00942: Table or view does not exist [message #533737 is a reply to message #533735] Thu, 01 December 2011 03:59 Go to previous message
abarnybox
Messages: 49
Registered: November 2011
Member
DW was probably my fault
but yeh its a different database and some of the tables have different names, though they mostly contain the same thing.
Previous Topic: Problem with Apex and primary key
Next Topic: Set X with Y when Branching
Goto Forum:
  


Current Time: Sat Sep 20 09:29:23 CDT 2014

Total time taken to generate the page: 0.12757 seconds