Explain GRANT command in MySQL.
- 1 Answers
- 504 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 |
How do you create a schema?
can you elaborate on blob and text in mysql? : Mysql dba
How many TRIGGERS are allowed in MySql table?
Why do gaps in sequences occur?
What is ACID?
Explain % and _ inside like statement?
What are the features of Stored Procedures in MYSQL?
What are the different data types in mysql?
Why do we use group by and order by function in mysql?
What is the latest mysql version?
What are CSV tables?
How do I start mysql from command line?
-
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)
