Re: Row-level security?
Date: Thu, 28 May 2009 15:47:47 -0500
> I understand that there are ways to feed values and variables from
> code into a RDBMS, but I wanted to know the SQL way to do it.
The *standard* SQL way to do it would be to have the application connect to the server as the required user in the first place, or if that is infeasible, use the SET SESSION AUTHORIZATION statement to assume the required user identity after connecting, then use the USER function as discussed previously.
-- RoyReceived on Thu May 28 2009 - 22:47:47 CEST