Give the syntax of Grant and Revoke commands?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What is procedural api?

716


How do I select a table in mysql?

694


Why do we use group by and order by function in mysql?

721


Can I use mysql for free?

671


Is foreign key indexed mysql?

655


Explain the storage engines in mysql?

771


Is mysqli secure?

668


What is dblink?

674


How to show certain selected rows with the value "pcds".

691


How do I start and stop mysql on windows?

707


What is difference between group by and order by clause?

746


What is mysqlcommand?

694


What is mysql data directory? How to determine the location of the data directory?

739


How is oracle different from mysql?

716


Hi Team, This is kartik, I recently completed my B-tech. Importance of posting this question is for to know the best books on SQL(MYSQL/Oracle)? I like SQL concept's so much, at the same time i decided to choose SQL for my career purpose. So please suggest me the best books that are very helpful for a fresher to improve concepts like (SQL/PLSQL)Basics, programming concepts, architectures etc. Please consider my request as an important one. I am very thankful to you for providing this opportunity. If possible can you please send the names of books for my personal id also: karthikgdv1206@yahoo.com. Thanks, Kartik T

1985