This is urgent, and I will appreciate very much your prompt reply.
When I am connecting to my Oracle DB, I get this error:
'ORA-00942: Table or view does not exist'.
Some backgroud information -
I have Microfocus Cobol as the front-end to my Oracle7 database. Recently, I started to help with the administration of the Oracle database. A few days ago I created a new user (say for this illustration, user BLOW). After creating user BLOW, I granted him these privileges: CREATE SESSION (so he can connect to my database) and SELECT ANY TABLE (so he can select from any table).
From within my Cobol program and on runtime, I am accepting both the Oracle username and the Password from the user and then use these values to connect to the Oracle DB.
My problem is when I connect as this new user (BLOW), I am getting the error above (i.e. 0RA-00942: Table or view does not exist) and I am not able to connect to the database. I just can't figure out why this error is coming up. I can connect to the database without any error (via my cobol program) when I connect as a user which was created previously by someone else (let's say this other user created by someone else is user BLACK). I checked out the roles granted to user BLACK and there were 2: CONNECT and RESOURCE. So I granted these roles to BLOW - but I still ended up with the same error when I connected as BLOW after granting the 2 roles.
Please, this is urgent. Will dearly appreciate your prompt reply.