CREATE PROCEDURE createUser (OUT param1 INT) BEGIN CREATE USER 'riya

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

Question Posted / riyas_isno

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

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

How to do login in mysql with unix shell.

1109

Can we save images in mysql database?

904

Is mysql running ubuntu?

986

Is mysql a backend?

929

Why is the basic difference between left join, right join and inner join?

1030

What is mysql command line?

1056

Can varchar be primary key?

924

Explain the architecture models of SQL Server?

2336

How is myisam table stored?

964

How much does mysql cost?

915

What is flush privileges in mysql?

996

What is the return type of mysqli_query?

869

What is pdo in php mysql?

946

What are queries used for?

952

What is the limitation of mysql?

967