← Back to branch summary

~skinny.moey/drizzle/innodb-replication

« back to all changes in this revision

Viewing changes to plugin/simple_user_policy/tests/r/basic.result

  • Committer: Brian Aker
  • Date: 2010-11-08 22:35:57 UTC
  • mfrom: (1802.1.114 trunk)
  • Revision ID: brian@tangent.org-20101108223557-w3xzwp9hjjtjhtc1
Merge in trunk.

Show diffs side-by-side

added added

removed removed

Lines of Context:
plugin/simple_user_policy/tests/r/basic.result
19
19
INFORMATION_SCHEMA
20
20
user1
21
21
SELECT * from user2.dont_exist;
22
 
ERROR 42000: Access denied for user 'user1'@'LOCALHOST' to database 'user2'
 
22
ERROR 42000: Access denied for user 'user1'@'LOCALHOST' to schema 'user2'
23
23
create database authorize_fail;
24
 
ERROR 42000: Access denied for user 'user1'@'LOCALHOST' to database 'authorize_fail'
 
24
ERROR 42000: Access denied for user 'user1'@'LOCALHOST' to schema 'authorize_fail'
25
25
drop database user2;
26
 
ERROR 42000: Access denied for user 'user1'@'LOCALHOST' to database 'user2'
 
26
ERROR 42000: Access denied for user 'user1'@'LOCALHOST' to schema 'user2'
27
27
create table t1 (kill_id int);
28
28
insert into t1 values(connection_id());
29
29
show processlist;
67
67
@id != connection_id()
68
68
1
69
69
connect(localhost,authz,,authz_no,MASTER_PORT,);
70
 
ERROR 42000: Access denied for user 'authz'@'LOCALHOST' to database 'authz_no'
 
70
ERROR 42000: Access denied for user 'authz'@'LOCALHOST' to schema 'authz_no'
71
71
drop schema user1;
72
72
drop schema user2;