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
7010 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

Is mysql a nosql database?

1115

What does mysql flush privileges do?

927

How do I create a new database in mysql?

899

What is bigint in mysql?

906

What are numeric data types?

979

How many primary keys can be there in a table?

980

Is there a free mysql?

880

What is a tinyint in mysql?

903

Is mysql free for enterprise?

887

What is difference between oracle sql and mysql?

1007

What is database engine in mysql?

930

What is localhost in mysql?

994

What is trigger in mysql with example?

908

How do I show users in mysql?

1042

How many columns can a mysql table have?

896