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

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
6888 Views
Infosys, Webyog, I also Faced
E-Mail Answers

Answer Posted / 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 View All Answers

Please Help Members By Posting Answers For Below Questions

how to dump all databases for backup. Backup file is sql commands to recreate all db's.

861

How do I exit mysql?

856

What is prepared statement in mysql?

900

Explain the storage engines in mysql?

949

What are the indexes in mysql?

941

What is mysql ndb?

847

can you elaborate on blob and text in mysql? : Mysql dba

843

How to return query output in xml format?

980

how to display nth highest salary from a table in a mysql query? : Mysql dba

999

Can you tell the difference between ereg_replace() and eregi_replace()?

982

What is the purpose of using ifnull() function?

898

Is mysql free for commercial use?

849

what is database black box testing? : Mysql dba

1057

What is data type for image in mysql?

824

What is mysql and how it works?

879