Re: Row-level security?
From: Roy Hann <specially_at_processed.almost.meat>
Date: Thu, 28 May 2009 15:47:47 -0500
Message-ID: <xKSdnXwW78zuZYPXnZ2dnUVZ8rednZ2d_at_pipex.net>
Date: Thu, 28 May 2009 15:47:47 -0500
Message-ID: <xKSdnXwW78zuZYPXnZ2dnUVZ8rednZ2d_at_pipex.net>
lawpoop wrote:
> 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