update table priv's in roles not working in 11G

From: gs <gs_at_gs.com>
Date: Wed, 12 May 2010 15:27:12 GMT
Message-ID: <kNzGn.3820$Z6.3665_at_edtnps82>

One of the databases I recently converted to 11Gr2 is showing me errors when an outside process tries to update a table via ODBC connection. This is a simple SQL update statement and is not from within a stored procedure. I am getting ORA-01031 after pointing the process to the new database, I checked the users roles, object priv's etc. and is identical to 9i, role basically gives said user read/write/update/delete on all of another users tables, one of which is the problem table.

I tried the statement directly from sql as the user, and still threw a ORA-01031, so I granted update on the table directly and it was ok.

Why would this be different in 11G? I'm also getting some strange errors where some of these processes are throwing "table not found" errors when   using a public synonym for the table, yet the synonyms are all in place and work fine from SQL prompt when using them with the same user acct the processes use.

thanks Received on Wed May 12 2010 - 10:27:12 CDT

Original text of this message