Hi All,
I was wondering if there are changes made to granting roles on ORACLE 9.2.0? I imported a user and his schema into ORACLE 9.2.0 with the option grants = Y after having imported it from ORACLE 9.0.1 with the same option grants = Y.

However when I try to select from any of the tables under that schema I get the error "ORA-00942: table of view does not exist. I have granted select on all the tables in that user's schema and still can select from it unless I put the schema name then the table name.

Any Ideas? Thanks in advance.

Mee