©SQL :: Manager
HomeProgram InformationTechnical detailsFree downloadDonate for a cup of coffee
myway SQL Manager for MySQL and MariaDB, Download on Uptodown
Database permissions of MySQL and MariaDB user accounts

Edit access rights of MySQL and MariaDB user accounts for database

Database user This module is part of the database administration and configuration
MyWAY - Edit database user permissions for database

Module for editing database user permissions on the MySQL Server.

Edit permissions for the database.

Edit permissions for database objects (tables, table columns, views, procedures and functions).

Global rights: The permissions are determined on a global level.
Switching off causes the permissions to be copied from the global level to the database level.

Set permissions Set all permissions for the database user
Revoke permissions Revoke all permissions for the database user
Color information Displays the color information for permission dependencies
FLUSH PRIVILEGS Reload privileges (FLUSH PRIVILEGS)
User permissions Edit user rights for database.
Table permissions Edit user rights for tables.
Table column permissions Edit user rights for table columns.
View permissions Edit user rights for views.
Procedure permissions Edit user rights for procedures.
Function permissions Edit user rights for functions.
MySQL - Edit database user permissions - Menu

Labeled menu by double-clicking title bar.

MySQL - Edit database user permissions for tables of the database - User selection

Edit database user permissions for tables in the database via user selection.

Parent rights: The permissions are determined by the higher level (global, database).
Turn off causes the permissions from the higher level to be copied to the table level.

MySQL - Edit database user permissions for tables of the database - Table selection

Edit database user permissions for tables in the database via table selection.

Parent rights: The permissions are determined by the higher level (global, database).
Turn off causes the permissions from the higher level to be copied to the table level.

MySQL - Edit database user permissions for table columns - Selection via user / table

Edit database user permissions for table columns with selection via user and table.

Parent rights: The permissions are determined by the higher level (global, database, table).
Turn off causes the permissions from the higher level to be copied to the table column level.

MySQL - Edit database user permissions for table columns - Selection via table / user

Edit database user permissions for table columns with selection via table and user.

Parent rights: The permissions are determined by the higher level (global, database, table).
Turn off causes the permissions from the higher level to be copied to the table column level.

MySQL - Edit database user permissions for table columns - Selection via table / table columns

Edit database user permissions for table columns with selection via table and table column.

Parent rights: The permissions are determined by the higher level (global, database, table).
Turn off causes the permissions from the higher level to be copied to the table column level.

MySQL - Edit database user permissions for views of the database - User selection

Edit database user permissions for views in the database via user selection.

Parent rights: The permissions are determined by the higher level (global, database).
Turn off causes the permissions from the higher level to be copied to the view level.

MySQL - Edit database user permissions for views of the database - View selection

Edit database user permissions for views in the database via view selection.

Parent rights: The permissions are determined by the higher level (global, database).
Turn off causes the permissions from the higher level to be copied to the view level.

MySQL - Edit database user permissions for procedures of the database - User selection

Edit database user permissions for procedures in the database via user selection.

Parent rights: The permissions are determined by the higher level (global, database).
Turn off causes the permissions from the higher level to be copied to the procedure level.

MySQL - Edit database user permissions for procedures of the database - Procedure selection

Edit database user permissions for procedures in the database via procedure selection.

Parent rights: The permissions are determined by the higher level (global, database).
Turn off causes the permissions from the higher level to be copied to the procedure level.

MySQL - Edit database user permissions for functions of the database - User selection

Edit database user permissions for functions in the database via user selection.

Parent rights: The permissions are determined by the higher level (global, database).
Turn off causes the permissions from the higher level to be copied to the function level.

MySQL - Edit database user permissions for functions of the database - Function selection

Edit database user permissions for functions in the database via function selection.

Parent rights: The permissions are determined by the higher level (global, database).
Turn off causes the permissions from the higher level to be copied to the function level.

More information about table level permissions: Table permissions
View level permissions: View permissions
Permissions at procedure and function level: Routine permissions
Updated: 2023-09-15ImprintContactTerms & conditionsPrivacy & CookiesUpdatesSitemapFacebookLinkedinTwitterStatistics©2020-2024 Heino Cunze-Fischer