Give the syntax of Grant and Revoke commands?

Question Posted / pranab

1 Answers
9321 Views
I also Faced
E-Mail Answers

Give the syntax of Grant and Revoke commands?..

Answer / monika

grant all on table_name to user_name;

Revoke all on table_name from user_name;

Is This Answer Correct ?

16 Yes

2 No

Post New Answer

More MySQL Interview Questions

The structure of table view buyers is as follows: +----------------+-------------+------+-----+---------+----- -----------+ | Field | Type | Null | Key | Default | Extra | +----------------+-------------+------+-----+---------+----- -----------+ | user_pri_id | int(15) | | PRI | NULL | auto_increment | | userid | varchar(10) | YES | | NULL | | +----------------+-------------+------+-----+---------+----- -----------+ the value of user_pri_id the last row 2345 then What will happen in the following conditions? Condition1: Delete all the rows and insert another row then. What is the starting value for this auto incremented field user_pri_id , Condition2: Delete the last row(having the field value 2345) and insert another row then. What is the value for this auto incremented field user_pri_id

2 Answers

What is the difference between database and table?

0 Answers

What happens if null values are involved in expressions?

0 Answers

What is mysql database used for?

0 Answers

How internally data stores in MyISAM and INNODB table types?

0 Answers Zensar,

What is procedural api?

0 Answers

Write a query to fetch duplicate records from a table using mysql?