write a c++ program to add a user to mysql.the user should be permitted to onl

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

Question Posted / shashwat044

3 Answers
6312 Views
Infosys, Webyog, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

Answer / 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

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

Answer / shashwat044

pls reply asap

Is This Answer Correct ?

2 Yes

1 No

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

Answer / riyas_isno

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

hope this will be the answer ....try it......

Is This Answer Correct ?

0 Yes

1 No

Post New Answer