diff options
| author | Vicențiu Ciorbaru <cvicentiu@gmail.com> | 2015-02-09 17:16:55 +0200 |
|---|---|---|
| committer | Vicențiu Ciorbaru <cvicentiu@gmail.com> | 2015-02-09 17:16:55 +0200 |
| commit | 4c69a6fff267f4c80ef1b360985b831932353c10 (patch) | |
| tree | 14eff80432081255233bf086a9492215bab24156 /mysql-test/suite/roles/recursive.result | |
| parent | bceb0b0be10bfbcd49981fa48981ca9b491b868e (diff) | |
| download | mariadb-git-4c69a6fff267f4c80ef1b360985b831932353c10.tar.gz | |
MDEV-6918 Create a way to see a user's default role.
Added an extra column to i_s_applicable_roles, named IS_DEFAULT.
The column displays which role is the default role for the user
querying the table.
Diffstat (limited to 'mysql-test/suite/roles/recursive.result')
| -rw-r--r-- | mysql-test/suite/roles/recursive.result | 24 |
1 files changed, 12 insertions, 12 deletions
diff --git a/mysql-test/suite/roles/recursive.result b/mysql-test/suite/roles/recursive.result index ef40c97865f..7abbd01240e 100644 --- a/mysql-test/suite/roles/recursive.result +++ b/mysql-test/suite/roles/recursive.result @@ -28,18 +28,18 @@ Grants for foo@localhost GRANT USAGE ON *.* TO 'foo'@'localhost' GRANT role10 TO 'foo'@'localhost' select * from information_schema.applicable_roles; -GRANTEE ROLE_NAME IS_GRANTABLE -foo@localhost role10 NO -role10 role9 NO -role2 role1 NO -role4 role2 NO -role5 role2 NO -role5 role3 NO -role6 role4 NO -role6 role5 NO -role7 role5 NO -role9 role6 NO -role9 role7 NO +GRANTEE ROLE_NAME IS_GRANTABLE IS_DEFAULT +foo@localhost role10 NO NO +role10 role9 NO NULL +role2 role1 NO NULL +role4 role2 NO NULL +role5 role2 NO NULL +role5 role3 NO NULL +role6 role4 NO NULL +role6 role5 NO NULL +role7 role5 NO NULL +role9 role6 NO NULL +role9 role7 NO NULL show status like 'debug%'; Variable_name Value grant select on *.* to role1; |