Lasso security and MySQL [WAS: Passing username and password toMySQL]

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Lasso security and MySQL [WAS: Passing username and password toMySQL]

Roddie Grant
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
Reply | Threaded
Open this post in threaded view
|

Re: Lasso security and MySQL [WAS: Passing username and password toMySQL]

Bil Corry
> 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