Re: Granting a role to a session ?

Hello, Richard,

near 12:17 01-Jul from richard.a.elliott_at_williams.com received:

> I want to grant an update role to a user when they connect from a
> client app.. This is so I can set up users in Oracle with no update
> privileges due to the same users using ODBC to run queries. I want the
> users to only be able to update the data if they are running a client
> that has row level security code in it. If I grant the update role to
> the user in the client, what keeps them from running the client, then
> connecting ODBC and running an update.

[...]

Grant update privileges to the role. Grant this role to user as not-default. Switch to this role in your (privileged) application. Enjoy. ;c)

-- 
wbr,
Wit.