privileges_by_table_by_level Sys Schema View
MariaDB starting with 11.4
This Sys Schema view was introduced in MariaDB 11.4.0.
Description
Shows granted privileges broken down by table on which they allow access and level on which they were granted.
For example, if a user x
has SELECT
privilege granted ON db.*
, this view will list all tables in the db
schema with the user x
having SELECT
privilege on them. This is different from INFORMATION_SCHEMA.TABLE_PRIVILEGES, which only lists privileges granted on the table level.
Column | Description |
---|---|
TABLE_SCHEMA | |
TABLE_NAME | |
GRANTEE | |
PRIVILEGE | |
LEVEL |
See Also
Comments
Comments loading...
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.