adspace


write a c++ program to add a user to mysql.the user should be
permitted to only "insert" into the given database

Answer Posted / riyas_isno

CREATE PROCEDURE createUser (OUT param1 INT)
BEGIN
CREATE USER 'riyaz'@'localhost' IDENTIFIED BY 'riyaz';
GRANT insert ON db1.* TO 'riyaz'@'localhost';
END

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is current version of mysql?

1085


How to Change a users password from unix shell.

1223


Which statement is used in a select query for partial matching?

1247


What is the current mysql version?

1105