Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

I can't access any tables on my oracle database.

When selecting the table product I get ORA-00942: table or view does not exist

I have tried this solution but I don't have sufficiƫnt rights to add a new user. I get ORA-01031: insufficient privileges

I am logged on as ADMIN to oracle application express.

The environment we use is windows server 2003.

What can I do to 1) access my tables and 2) get back the administration rights I am supposed to have?

share|improve this question
    
Might want to address this in the dba group. –  mdpc Dec 14 '12 at 22:50
    
sorry forgot to mention, Administrator is in ORA_DBA group –  Forza Dec 14 '12 at 22:51
    
I'm a bit confused. ADMIN is normally an Oracle APEX user. That would mean that it has the ability to create other APEX users but not to create database users or to grant privileges. The privileges APEX developers have are based on the Oracle schema that the APEX workspace is configured to use. The ORA_DBA group is a Windows group so it would only apply to Windows users not database users or APEX users. From your description, it appears that whatever database account APEX uses lacks some privilege-- your DBA would need to grant those. –  Justin Cave Dec 17 '12 at 15:43

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.