write a c++ program to add a user to mysql.the user should be
permitted to only "insert" into the given database
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
How to define numeric 9(3) in db2 table without decimal point??
How many ways we can we find the current date using MySQL?
How to control the max size of a heap table?
How do I truncate all tables in mysql?
What is the difference between unix timestamp and mysql timestamp?
What is the difference between SQL and SQL Server?
What is pdo connection?
What is the usage of "i-am-a-dummy" flag in mysql?
How to use in conditions?
Is mysql relational database?
How do I check mysql version?
What is text?