← Back to branch summary

~ubuntu-branches/ubuntu/maverick/mysql-5.1/maverick-proposed

« back to all changes in this revision

Viewing changes to mysql-test/suite/funcs_1/r/innodb_trig_03e.result

  • Committer: Package Import Robot
  • Author(s): Marc Deslauriers
  • Date: 2012-02-22 14:16:05 UTC
  • mto: This revision was merged to the branch mainline in revision 20.
  • Revision ID: package-import@ubuntu.com-20120222141605-nxlu9yzc6attylc2
Tags: upstream-5.1.61
Import upstream version 5.1.61

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/suite/funcs_1/r/innodb_trig_03e.result
24
24
Grants for test_noprivs@localhost
25
25
GRANT USAGE ON *.* TO 'test_noprivs'@'localhost' IDENTIFIED BY PASSWORD '*C49735D016A099C0CF104EF9183F374A54CA2576'
26
26
GRANT SELECT, INSERT ON `priv_db`.* TO 'test_noprivs'@'localhost'
27
 
connect(localhost,test_yesprivs,PWD,test,MASTER_MYPORT,MASTER_MYSOCK);
28
27
 
29
28
no trigger privilege on db level for create:
30
29
--------------------------------------------
32
31
create trigger trg1_1 before INSERT on t1 for each row
33
32
set new.f1 = 'trig 1_1-no';
34
33
ERROR 42000: TRIGGER command denied to user 'test_yesprivs'@'localhost' for table 't1'
35
 
connect(localhost,test_noprivs,PWD,test,MASTER_MYPORT,MASTER_MYSOCK);
36
34
use priv_db;
37
35
insert into t1 (f1) values ('insert-yes');
38
36
select f1 from t1 order by f1;
253
251
create User test_noprivs@localhost;
254
252
set password for test_noprivs@localhost = password('PWD');
255
253
revoke ALL PRIVILEGES, GRANT OPTION FROM test_noprivs@localhost;
256
 
connect(localhost,test_yesprivs,PWD,test,MASTER_MYPORT,MASTER_MYSOCK);
257
 
connect(localhost,test_noprivs,PWD,test,MASTER_MYPORT,MASTER_MYSOCK);
258
254
 
259
255
no trigger privilege on table level for create:
260
256
-----------------------------------------------
513
509
show grants for test_noprivs@localhost;
514
510
Grants for test_noprivs@localhost
515
511
GRANT SELECT, INSERT ON *.* TO 'test_noprivs'@'localhost' IDENTIFIED BY PASSWORD '*C49735D016A099C0CF104EF9183F374A54CA2576'
516
 
connect(localhost,test_yesprivs,PWD,test,MASTER_MYPORT,MASTER_MYSOCK);
517
 
connect(localhost,test_noprivs,PWD,test,MASTER_MYPORT,MASTER_MYSOCK);
518
512
select current_user;
519
513
current_user
520
514
test_yesprivs@localhost
563
557
show grants for test_yesprivs@localhost;
564
558
Grants for test_yesprivs@localhost
565
559
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, SHUTDOWN, PROCESS, FILE, REFERENCES, INDEX, ALTER, SHOW DATABASES, SUPER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER, EVENT ON *.* TO 'test_yesprivs'@'localhost' IDENTIFIED BY PASSWORD '*C49735D016A099C0CF104EF9183F374A54CA2576'
566
 
connect(localhost,test_yesprivs,PWD,test,MASTER_MYPORT,MASTER_MYSOCK);
567
560
select current_user;
568
561
current_user
569
562
test_yesprivs@localhost
698
691
f1
699
692
insert-yes
700
693
insert-yes
701
 
connect(localhost,test_yesprivs,PWD,test,MASTER_MYPORT,MASTER_MYSOCK);
702
694
select current_user;
703
695
current_user
704
696
test_yesprivs@localhost
767
759
GRANT USAGE ON *.* TO 'test_noprivs'@'localhost' IDENTIFIED BY PASSWORD '*C49735D016A099C0CF104EF9183F374A54CA2576'
768
760
GRANT SELECT, INSERT, UPDATE ON `priv1_db`.* TO 'test_noprivs'@'localhost'
769
761
GRANT SELECT, INSERT ON `priv2_db`.* TO 'test_noprivs'@'localhost'
770
 
connect(localhost,test_yesprivs,PWD,test,MASTER_MYPORT,MASTER_MYSOCK);
771
762
use priv1_db;
772
 
connect(localhost,test_noprivs,PWD,test,MASTER_MYPORT,MASTER_MYSOCK);
773
763
use priv1_db;
774
764
 
775
765
trigger privilege on one db1 db level, not on db2
982
972
set password for test_useprivs@localhost = password('PWD');
983
973
revoke ALL PRIVILEGES, GRANT OPTION FROM test_yesprivs@localhost;
984
974
revoke ALL PRIVILEGES, GRANT OPTION FROM test_useprivs@localhost;
985
 
connect(localhost,test_yesprivs,PWD,test,MASTER_MYPORT,MASTER_MYSOCK);
986
975
select current_user;
987
976
current_user
988
977
root@localhost
1010
999
f1
1011
1000
trig 1_1-yes
1012
1001
prepare ins1 from 'insert into t1 (f1) values (''insert2-no'')';
1013
 
connect(localhost,test_useprivs,PWD,test,MASTER_MYPORT,MASTER_MYSOCK);
1014
1002
select current_user;
1015
1003
current_user
1016
1004
test_useprivs@localhost
1206
1194
create User test_yesprivs@localhost;
1207
1195
set password for test_yesprivs@localhost = password('PWD');
1208
1196
revoke ALL PRIVILEGES, GRANT OPTION FROM test_yesprivs@localhost;
1209
 
connect(localhost,test_yesprivs,PWD,test,MASTER_MYPORT,MASTER_MYSOCK);
1210
1197
select current_user;
1211
1198
current_user
1212
1199
root@localhost
1303
1290
create User test_yesprivs@localhost;
1304
1291
set password for test_yesprivs@localhost = password('PWD');
1305
1292
revoke ALL PRIVILEGES, GRANT OPTION FROM test_yesprivs@localhost;
1306
 
connect(localhost,test_yesprivs,PWD,test,MASTER_MYPORT,MASTER_MYSOCK);
1307
1293
select current_user;
1308
1294
current_user
1309
1295
root@localhost
1375
1361
Grants for test_noprivs@localhost
1376
1362
GRANT USAGE ON *.* TO 'test_noprivs'@'localhost' IDENTIFIED BY PASSWORD '*C49735D016A099C0CF104EF9183F374A54CA2576'
1377
1363
GRANT SELECT, UPDATE ON `priv_db`.* TO 'test_noprivs'@'localhost'
1378
 
connect(localhost,test_yesprivs,PWD,test,MASTER_MYPORT,MASTER_MYSOCK);
1379
 
connect(localhost,test_noprivs,PWD,test,MASTER_MYPORT,MASTER_MYSOCK);
1380
1364
 
1381
1365
update only on column:
1382
1366
----------------------