OraFAQ Forum: Application Express, ORDS & MOD_PLSQL » ORA-00942: Table or view does not exist

Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » ORA-00942: Table or view does not exist (Application Express, 4.0, windows 7)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-00942: Table or view does not exist [message #533695]

Thu, 01 December 2011 02:39

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

Report message to a moderator

Re: ORA-00942: Table or view does not exist [message #533709 is a reply to message #533695]

Thu, 01 December 2011 03:12

abarnybox
Messages: 49
Registered: November 2011

Member

Its ok I sorted it.

Report message to a moderator

Re: ORA-00942: Table or view does not exist [message #533710 is a reply to message #533709]

Thu, 01 December 2011 03:14

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

How?

Report message to a moderator

Re: ORA-00942: Table or view does not exist [message #533725 is a reply to message #533710]

Thu, 01 December 2011 03:42

abarnybox
Messages: 49
Registered: November 2011

Member

the ADMIN authorization scheme had the code

Code: [Select all] [Show/ hide]

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.

Report message to a moderator

Re: ORA-00942: Table or view does not exist [message #533726 is a reply to message #533725]

Thu, 01 December 2011 03:45

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Changed what exactly? FM_ADMIN.MUID (from 'MD_ADMIN' to 'ADMIN')?

Report message to a moderator

Re: ORA-00942: Table or view does not exist [message #533732 is a reply to message #533726]

Thu, 01 December 2011 03:51

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.

Report message to a moderator