Granting and Revoking Privileges in MySQL

You probably want to grant yourself some privileges, and eventually you will probably want to grant privileges to other users. Privileges, also known as rights, are granted and revoked on four levels:

• Global-level These rights allow access to any database on a server.

• Database-level These rights allow access to all tables in a database.

• Table-level These rights allow access to all columns within a table in a database.

• Column-level These rights allow access to a single column within a database's table.

Was this article helpful?

0 0

Post a comment