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 '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
How to include numeric values in sql statements?
What is mysql protocol?
How many columns can a table have?
How can you retrieve a particular number of records from a table?
Is mysql connect deprecated?
Which statement is used in a select query for partial matching?
Transactions are used to treat sets of SQL statements atomically. State Whether True or False?
What is a scalar function?
Is mysql from oracle?
How do I remove a user from mysql?
What is ntext?
What's new in mysql 8?
How do I edit a trigger in mysql?
Why do we use group by and order by function in mysql?
In which language it is written?