Re: update table priv's in roles not working in 11G
Date: Thu, 13 May 2010 00:18:30 +0000 (UTC)
Message-ID: <hsfggm$s0m$2_at_news.eternal-september.org>
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.
>
>
> thanks
Did you switch to the new 11G security? 11G can distinguish between upper case and lower case so your password may no longer match.
-- http://mgogala.byethost5.comReceived on Wed May 12 2010 - 19:18:30 CDT