Re: Lasso security and MySQL [WAS: Passing username and passwordtoMySQL]

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

Re: Lasso security and MySQL [WAS: Passing username and passwordtoMySQL]

Roddie Grant
Thanks Bil

That was the conclusion I'd come to, but it's not what the setup guide
implies, so I was hoping I was wrong, and it could be handled at a more
refined level.

Roddie



on 10/6/05 23:15, Bil Corry at [hidden email] wrote:

>> Someone tell me I'm wrong!
>
> You have to create a different host for each MySQL user.
>
>
> - Bil
>
> ------
>
> Bil Corry
> [hidden email]
>
> Enterprise internet application development and security consulting
> http://www.fivegeeks.com/
>
> Tools for Rapid Lasso Development
> http://www.lassoware.com/
>
> -----Original Message-----
> From: [hidden email] [mailto:[hidden email]] On Behalf
> Of
> Roddie Grant
> Sent: Thursday, June 09, 2005 8:37 AM
> To: [hidden email]
> Subject: Lasso security and MySQL [WAS: Passing username and password toMySQL]
>
> So, just to be clear:
>
> Even if I do (in MySQL)
> GRANT SELECT ON demo.demo1 To john@localhost IDENTFIED BY 'armadillo'
> and
> GRANT UPDATE ON demo.demo1 To fred@localhost IDENTFIED BY 'anteater'
>
> there is no point in using (in Lasso 6.0.6)
> inline: -Username='john', -Password='armadillo', -sql = 'SELECT...';/inline;
> and
> inline: -Username='fred', -Password='anteater', -sql = 'UPDATE...';/inline;
>
> because Lasso will connect to MySQL with the username and password for the
> host.
>
> Someone tell me I'm wrong!
>
> Roddie Grant
> [hidden email]
>
>
>


--
------------------------------
Lasso Support: http://support.omnipilot.com/
Search the list archives: http://www.listsearch.com/lassotalk.lasso
Manage your list subscription:  
http://www.listsearch.com/lassotalk.lasso?manage