Thanks Jon.
regards
anandkl
On 6/8/07, Jon Ribbens <[EMAIL PROTECTED]> wrote:
On Fri, Jun 08, 2007 at 04:25:00PM +0530, Ananda Kumar wrote:
>So, what ever i did is right?
Yes. User 'ab' can SELECT on all tables in database 'abc'.
--
MySQL General Mailing List
For list archives: http://l
On Fri, Jun 08, 2007 at 04:25:00PM +0530, Ananda Kumar wrote:
>So, what ever i did is right?
Yes. User 'ab' can SELECT on all tables in database 'abc'.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi Juan,
Do you me "all table in database abc". Please confirm.
Is it a typo or something else.
regards
anandkl
On 6/8/07, Juan Eduardo Moreno <[EMAIL PROTECTED]> wrote:
Hi,
Try to do that :
GRANT SELECT ON abc.* to 'qa'@'%' identified by 'qa';
flush privileges;
Explain : The user qa hav
Hi,
Try to do that :
GRANT SELECT ON abc.* to 'qa'@'%' identified by 'qa';
flush privileges;
Explain : The user qa have access of all tables of user abc. In this
command, only SELECT is possible is you connect using user qa.
Regards,
Juan
On 6/8/07, Ananda Kumar <[EMAIL PROTECTED]> wrote:
Hi Jon,
So, what ever i did is right?
please let me know.
regards
anandkl
On 6/8/07, Jon Ribbens <[EMAIL PROTECTED]> wrote:
On Fri, Jun 08, 2007 at 03:14:18PM +0530, Ananda Kumar wrote:
> How do i give only select privilege to a specific database.
>
> GRANT SELECT ON abc.* to 'ab'@'%' identi
On Fri, Jun 08, 2007 at 03:14:18PM +0530, Ananda Kumar wrote:
> How do i give only select privilege to a specific database.
>
> GRANT SELECT ON abc.* to 'ab'@'%' identified by 'ab';
Like that.
> mysql> select select_priv from user where user='qa';
> +-+
> | select_priv |
> +-
