How Many Scope Levels Can User Privileges Apply

Home > MySQL > Admin

Q

How Many Scope Levels Can User Privileges Apply? - MySQL FAQs - Managing User Accounts and Access Privileges

✍: FYIcenter.com

A

MySQL supports 5 scope levels a user privilege can be granted:

Global Level - A privilege granted at this level applies to all databases on the server. Privileges granted at the global level stored in "mysql.user" table.
Database Level - A privilege granted at this level applies to all tables in the specified database. Privileges granted at the global level stored in "mysql.db" table.
Table Level - A privilege granted at this level applies to all columns in the specified table. Privileges granted at the global level stored in "mysql.tables_priv" table.
Column Level - A privilege granted at this level applies to only the specified column. Privileges granted at the global level stored in "mysql.columns_priv" table.
Routine Level - A privilege granted at this level applies to only the specified stored function procedure. Privileges granted at the global level stored in "mysql.procs_priv" table.

2007-05-10, 4883👍, 0💬

How To Give a User Read-Only Access to a Database
How To Give a User Read-Only Access to a Database? - MySQL FAQs - Managing User Accounts and Access Privileges 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 DELET... 2007-05-08, 7606👍, 0💬

How To Revoke User Privileges
How To Revoke User Privileges? - MySQL FAQs - Managing User Accounts and Access Privileges If your want remove some granted user privileges, you can use the "REVOKE privilegeName ..." command. You can only revoke privileges in the same way as they were granted. For example, you can not revoke a priv... 2007-05-08, 5833👍, 0💬

How To View User Privileges
How To View User Privileges? - MySQL FAQs - Managing User Accounts and Access Privileges If a regular user wants to see his/her own granted privileges, he/she can use the "SHOW GRANTS" command. If the "root" user wants to see other user's granted privileges, he/she can use the "SHOW GRANTS FOR userN... 2007-05-10, 5657👍, 0💬

How To Delete a User Account
How To Delete a User Account? - MySQL FAQs - Managing User Accounts and Access Privileges If you want to delete a user account, you can connect to the server as "root" and use the "DROP USER ..." command to delete a user account. The tutorial exercise below shows you a good example: >cd \mysql\bin >... 2007-05-10, 5535👍, 0💬

How To Grant User Privileges at the Database Level
How To Grant User Privileges at the Database Level? - MySQL FAQs - Managing User Accounts and Access Privileges If you want to grant a user privilege at the database level, you can use the "GRANT privilegeName ON databaseName.* TO userName" command. The argument "databasename.*" in the command stand... 2007-05-10, 5505👍, 0💬

How To List All Existing User Accounts
How To List All Existing User Accounts? - MySQL FAQs - Managing User Accounts and Access Privileges MySQL stores all existing user accounts in a table called "mysql.user". If you want see all user accoutns, you can use the "SELECT" command as shown in the tutorial exercise below: >cd \mysql\bin >mys... 2007-05-10, 5363👍, 0💬

What Are User Privileges
What Are User Privileges? - MySQL FAQs - Managing User Accounts and Access Privileges MySQL offers many user privileges to control user accesses to different funtions and data objects. Here are some commonly used privileges: ALL - All privileges. CREATE - Allows the user to use CREATE TABLE commands... 2007-05-10, 5339👍, 0💬

How To Rename an Existing User Account Name
How To Rename an Existing User Account Name? - MySQL FAQs - Managing User Accounts and Access Privileges If you want to change the name of an existing user account, you can use the "RENAME USER oldName TO newName" command. The tutorial exercise below shows you how to do this: >cd \mysql\bin >mysql -... 2007-05-10, 5163👍, 0💬

How To Grant User Privileges at the Global Level
How To Grant User Privileges at the Global Level? - MySQL FAQs - Managing User Accounts and Access Privileges If you want to grant a user privilege at the global level, you can use the "GRANT privilegeName ON *.* TO userName" command. The argument "*.*" in the command stands for all database and all... 2007-05-10, 5105👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.