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 '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
what is constraints?
What is mysql ndb?
What is a tinyint in mysql?
What is a select query?
How to dump a table to a file with 'mysqldump'?
What is difference between mysql and mysql server?
Suppose you have to collect the first name, middle name and the last name of students from the below table. But, you observe that there few missing values either in the first name, middle name and the last name columns. How will you return the first non-null values?
what is the default port for mysql server? : Mysql dba
What is logs in mysql?
Can you tell how many values can set the function of mysql to consider?
What do you mean by % and _ in the LIKE statement?
What is indexing in mysql?
What is mysql server used for?
Are stored procedures precompiled?
How to define numeric 9(3) in db2 table without decimal point??