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

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Wed, 12 May 2010 18:08:27 +0200
Message-ID: <4bead279$0$17875$>

"gs" <> a écrit dans le message de news: 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

Assuming you didn't miss anything the cause may be that roles identified by password or package are no more activated by default even if they are declared as default roles.

Michel Received on Wed May 12 2010 - 11:08:27 CDT

Original text of this message