Home >> FAQs/Tutorials >> MySQL Tutorials

MySQL Tutorial - Giving User Read-only Access

By: FYIcenter.com

(Continued from previous topic...)

How To Give a User Read-Only Access to a Database?

If you want give a user read-only access to a database, you can grant to him/her only the "SELECT" privilege, so that he/she can not run any DDL statements, and any INSERT, UPDATE, or DELETE statements. The tutorial exercise gives you a good example:

>cd \mysql\bin
>mysql -u root -pretneciyf

mysql> USE fyi;
Database changed

mysql> CREATE TABLE links (id INTEGER, name VARCHAR(80));
Query OK, 0 rows affected (0.14 sec)

mysql> INSERT INTO links VALUES (1, 'dba.fyicenter.com');
Query OK, 1 row affected (0.05 sec)

mysql> CREATE USER guest IDENTIFIED BY 'pub';
Query OK, 0 rows affected (0.24 sec)

mysql> GRANT SELECT ON fyi.* TO guest;
Query OK, 0 rows affected (0.00 sec)

mysql> QUIT;

>mysql -u guest -ppub

mysql> use fyi;
Database changed

mysql> SELECT * FROM links;
+------+-------------------+
| id   | name              |
+------+-------------------+
|    1 | dba.fyicenter.com |
+------+-------------------+
1 row in set (0.04 sec)

mysql> INSERT INTO links VALUES (2, 'dev.fyicenter.com');
ERROR 1142 (42000): INSERT command denied to user 
 'guest'@'localhost' for table 'links'

(Continued on next topic...)

  1. What Is a User Account?
  2. What Are the Predefined User Accounts?
  3. How To Add a New User Account?
  4. How To Test a New User Account and Password?
  5. How To Change the Password for Your Own User Account?
  6. How To Change the Password of Another User Account?
  7. How To Delete a User Account?
  8. How To List All Existing User Accounts?
  9. How To Rename an Existing User Account Name?
  10. What Are User Privileges?
  11. How Many Scope Levels Can User Privileges Apply?
  12. How To Grant User Privileges at the Global Level?
  13. How To Grant User Privileges at the Database Level?
  14. How To View User Privileges?
  15. How To Revoke User Privileges?
  16. How To Give a User Read-Only Access to a Database?
  17. Where Are User Privileges Stored on the Server?

MySQL Tutorials:

More...


Other Tutorials/FAQs:

More...


Related Resources:

More...


Selected Jobs:

More...