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]
x27;;
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:
>
> How do i give only select privilege to a specific
umar <[EMAIL PROTECTED]> wrote:
How do i give only select privilege to a specific database.
I did this
GRANT SELECT ON abc.* to 'ab'@'%' identified by 'ab';
FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)
mysql> select select_priv from user
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 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
How do i give only select privilege to a specific database.
I did this
GRANT SELECT ON abc.* to 'ab'@'%' identified by 'ab';
FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)
mysql> select select_priv from user where user='qa';
+---
