Mysql – How to grant and revoke rights to tables using phpMyAdmin

MySQLpermissions

Is phpMyAdmin capable of granting rights (permissions) on certain tables to users or roles?

When I look at the page of a database table there is no "rights" tab.

I have only found a place where I can give rights to single users.

What I need is granting some rights to several users at the same time like

grant insert, update, delete on customers to john, max, annie;

You can do that. Follow the pictures: In the "Privileges" tab which list your users click the "Edit Privileges" of the user.

Then select the database:

After that specific the privileges by checking them and then select your table as shown in the picture:

After you select your table, you can define the operations in detailed:

Mass GRANT/REVOKE is only available on PostgreSQL 9.0+.

The parameters to both functions are:

You will need to run the command on each database and each schema. The syntax looks like this:

SELECT pg_grant('web_user','SELECT,INSERT,UPDATE,DELETE','%','public');

If you like, you may be able to change this line in the function definition:

nspname = $4 AND

to this:

nspname like $4 AND

in order to be able to specify schema as a wildcard, but I haven't tested it.

I don't think you need a special permission for doing that.
I just created a new user (GRANT USAGE only) and was able to change my password via:

SET PASSWORD = password('bla');