Re: update table priv's in roles not working in 11G
Date: Thu, 13 May 2010 00:18:30 +0000 (UTC)
On Wed, 12 May 2010 15:27:12 +0000, gs wrote:
> 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.
Did you switch to the new 11G security? 11G can distinguish between upper case and lower case so your password may no longer match.Received on Wed May 12 2010 - 19:18:30 CDT