← Back to branch summary

~ubuntu-branches/ubuntu/wily/mysql-5.6/wily

« back to all changes in this revision

Viewing changes to mysql-test/r/ps_grant.result

  • Committer: Package Import Robot
  • Author(s): Marc Deslauriers
  • Date: 2015-04-16 20:07:10 UTC
  • mto: (1.3.9 vivid-proposed)
  • mto: This revision was merged to the branch mainline in revision 11.
  • Revision ID: package-import@ubuntu.com-20150416200710-pcrsa022082zj46k
Tags: upstream-5.6.24
Import upstream version 5.6.24

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/r/ps_grant.result
18
18
second_user@localhost
19
19
show grants for current_user();
20
20
Grants for second_user@localhost
21
 
GRANT USAGE ON *.* TO 'second_user'@'localhost' IDENTIFIED BY PASSWORD '*13843FE600B19A81E32AF50D4A6FED25875FF1F3'
 
21
GRANT USAGE ON *.* TO 'second_user'@'localhost' IDENTIFIED BY PASSWORD
22
22
GRANT SELECT ON `mysqltest`.`t9` TO 'second_user'@'localhost'
23
23
prepare s_t9 from 'select c1 as my_col 
24
24
                                 from t9 where c1= 1' ;
42
42
GRANT SELECT ON `mysqltest`.`t1` TO 'second_user'@'localhost'
43
43
show grants for second_user@localhost ;
44
44
Grants for second_user@localhost
45
 
GRANT USAGE ON *.* TO 'second_user'@'localhost' IDENTIFIED BY PASSWORD '*13843FE600B19A81E32AF50D4A6FED25875FF1F3'
 
45
GRANT USAGE ON *.* TO 'second_user'@'localhost' IDENTIFIED BY PASSWORD
46
46
GRANT SELECT ON `mysqltest`.`t9` TO 'second_user'@'localhost'
47
47
GRANT SELECT ON `mysqltest`.`t1` TO 'second_user'@'localhost'
48
48
prepare s_t1 from 'select a as my_col from t1' ;
62
62
GRANT SELECT ON `mysqltest`.`t9` TO 'second_user'@'localhost'
63
63
show grants for second_user@localhost ;
64
64
Grants for second_user@localhost
65
 
GRANT USAGE ON *.* TO 'second_user'@'localhost' IDENTIFIED BY PASSWORD '*13843FE600B19A81E32AF50D4A6FED25875FF1F3'
 
65
GRANT USAGE ON *.* TO 'second_user'@'localhost' IDENTIFIED BY PASSWORD
66
66
GRANT SELECT ON `mysqltest`.`t9` TO 'second_user'@'localhost'
67
67
execute s_t1 ;
68
68
ERROR 42000: SELECT command denied to user 'second_user'@'localhost' for table 't1'