Re: My sql Security

2010-04-28 Thread Vikram A
From: Johan De Meersman To: Vikram A Cc: MY SQL Mailing list Sent: Wed, 28 April, 2010 9:55:38 PM Subject: Re: My sql Security Rip out the DB authentication part, and store those credentials in-code, in some config file or the registry, or some remote mechanism like LDAP. If your

Re: My sql Security

2010-04-28 Thread Johan De Meersman
y login Authentication screen; I request you guide me how can > handle this. > > Thank you > > Vikram > > -- > *From:* Johan De Meersman > > *To:* Vikram A > *Cc:* MY SQL Mailing list > *Sent:* Wed, 28 April, 2010 2:10:45 PM > >

Re: My sql Security

2010-04-28 Thread Vikram A
from the other GUI/connecting tools though they have given a access to db? Thank you for the information. Vikram From: nwood To: Vikram A Cc: MY SQL Mailing list Sent: Wed, 28 April, 2010 3:39:23 PM Subject: Re: My sql Security On Wed, 2010-04-28 at 13:58

Re: My sql Security

2010-04-28 Thread nwood
On Wed, 2010-04-28 at 13:58 +0530, Vikram A wrote: > Hi all, > I have some security issues. I would like to have your suggestions/solutions. > > I have winserver2003 with mysql 5.1.45. We have client serve application that > allows multi-login system with various people. > > I am getting user na

Re: My sql Security

2010-04-28 Thread Johan De Meersman
I'm afraid you can't discern between clients and applications on the MySQL level. Your application authentication should be separate from the MySQL one. On Wed, Apr 28, 2010 at 10:28 AM, Vikram A wrote: > Hi all, > I have some security issues. I would like to have your > suggestions/solutions.

My sql Security

2010-04-28 Thread Vikram A
Hi all, I have some security issues. I would like to have your suggestions/solutions. I have winserver2003 with mysql 5.1.45. We have client serve application that allows multi-login system with various people. I am getting user name, password for database login when the try to use login [

Re: question about "sql security"

2006-01-11 Thread wangxu
thank you gleb. But,the "sql security"d description in the manual is not particular. I mistaked the concept. I understand the limit is procedure limit but not database object limit. So,i believe this concept should more definitude if you add the example in this part

Re: question about "sql security"

2006-01-04 Thread Peter Brawley
>I refer a question about "sql security" option of create procedure syntax >at 2005-12. But i can't quite understood with that answer. >Can you give me a example to describe the effect of set "sql security" >option ? CREATE PROCEDURE ... SQL SECURITY INVOK

Re: question about "sql security"

2006-01-04 Thread Gleb Paharenko
Hello. In my opinion, a good description can be found here: http://dev.mysql.com/tech-resources/articles/mysql-storedprocedures.html "wangxu" <[EMAIL PROTECTED]> wrote: -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET

question about "sql security"

2006-01-03 Thread wangxu
I refer a question about "sql security" option of create procedure syntax at 2005-12. But i can't quite understood with that answer. Can you give me a example to describe the effect of set "sql security" option ?

Re: how to use "sql security"

2005-12-27 Thread wangxu
How "sql security" option restrict privileges? - Original Message - From: "Paul DuBois" <[EMAIL PROTECTED]> To: "wangxu" <[EMAIL PROTECTED]>; Sent: Wednesday, December 28, 2005 3:21 PM Subject:Re: how to use "sql security" > At 1

Re: how to use "sql security"

2005-12-27 Thread Paul DuBois
At 15:17 +0800 12/28/05, wangxu wrote: User_one create a procdure named "proc" with option "sql security invoker". User_two only have "execute" privilege in the database that the "proc" in. But the User_two still call the "proc". What eff

how to use "sql security"

2005-12-27 Thread wangxu
User_one create a procdure named "proc" with option "sql security invoker". User_two only have "execute" privilege in the database that the "proc" in. But the User_two still call the "proc". What effect do the "sql security" option producing?

SQL SECURITY

2004-02-09 Thread K Sunil
Hi, I have created a stored procedure in mysql with definer sql security. If there is another user 'X' how to give him the invoker rights in the procedures itself. Thanks and Regards, Sunil.K -- MySQL General Mailing List For list archives: http://lists.mysql.co