Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

How to write date and time literals?

1075


how to Return total number of rows.

1057


How many queries can mysql handle?

1020


Which is faster mysql or mongodb?

983


What is MySQL?

1051


What is mysql common?

953


What is the default port for mysql and how it can change?

1107


What is meant by sharding?

985


What does do in mysql?

941


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?

1001


What is a trigger in mysql?

1086


How to enable or disable a row of a table using MySQL in struts?

4147


How to update a root password.

1000


How to create a table index in mysql?

1014


How to validate email addresses in mysql?

1174