I need some help regarding mysql

Asked By azalea gomez 0 points N/A Posted on - 03/08/2012

Hi guys,

I need to grant only select option to some selected user for a particular database,please anyone provide me mysql code to do this

• Status: Open
• Question Views: 824
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MySQL Server

Answered By Kanhai Else 0 points N/A #93524

I need some help regarding mysql

 

The following Queries are for MySQL Database.
Creating a User
CREATE USER 'usr'@'localhost' IDENTIFIED BY 'pass';
Granting all previlleges to 'usr' on every thing in database 'dbase1'.
GRANT ALL ON dbase1.* TO 'usr'@'localhost';
Granting SELECT option on table 'mytable' in database dbase2 to user 'usr'
GRANT SELECT ON dbase2.mytable TO 'usr'@'localhost';

In order to set permissions for multiple users, you need to specify all of them changing the usernames in the lase query.

 

However If you Make any mistake, you can alter by using the REVOKE command by typing

REVOKE ALL on < username >;

Granting DBA to any user gives him almost all permissions and can lead to unsecured data.

thanks.

About Kanhai Else

Questions
0

Answers
56

Best Answers
8

• Vote Up 0 Vote Down

• Posted on - 03/18/2012
• Question Category: MySQL Server