Explain GRANT command in MySQL.
- 1 Answers
- 484 Views
- I also Faced
- E-Mail Answers
When a new MySQL user is created, it requires certain privileges to perform various database operations.
GRANT command grants certain privileges to the user.
For example below statement grants permission to run SELECT and INSERT on TABLE customertable to user username@localhost.
GRANT SELECT, INSERT ON customertable TO ‘username’@’localhost’
| Is This Answer Correct ? | 0 Yes | 0 No |
What happens when the column is set to AUTO INCREMENT and if you reach maximum value in the table?
How much does mysql enterprise cost?
How would you get the current date in mysql?
How many types of indexes are there in mysql?
Is there a way to see the files which are stored?
Transactions are used to treat sets of SQL statements atomically. State Whether True or False?
Which mysql function is used to concatenate string?
What is heap table in mysql?
What is the data source name for mysql?
What is mysql protocol?
How to extract a unit value from a date and time?
what is the Dynamic management views? where can you use?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
