First of all, my details(I try to include as much as I can):
Oracle DB11G Enterprise Edition 220.127.116.11.0(Installed locally, default localhost setup)
Windows 7 64-Bit
I am trying to use the gii module to generate some models for testing purpose(as I am fairly new to this framework). I have imported all the tables/data from my organization's database, and have create related tablespaces and users. So my generator have these autocompleted when i typed partial keywords.
Then when I clicked on preview button, i get this error below
I believe the SYSTEM/SYSAUX are generated automatically when installing the oracle db. Plus, the autocomplete tables that appeared when I try to insert the table name is correct and same as the tables i have inside our schema. I tried changing the password/creds to be wrong as I cant access the gii page at all(so i believe the connection to my db setup is fine).
Can anyone help me. is it a known issue or i am doing something wrong? because as far as I understand, the error shown means that the generator is looking at a different place upon clicking the "preview" button.
ORA-00942: table or view does not exist
Looking at the failing SQL, it seems the user which is executing the query doesn't have the DBA privilege to access
dba_objects. You need to GRANT the required privilege to this user.
GRANT DBA to new_user;