← 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/myisam_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/myisam_trig_03e.result
25
25
Grants for test_noprivs@localhost
26
26
GRANT USAGE ON *.* TO 'test_noprivs'@'localhost' IDENTIFIED BY PASSWORD '*C49735D016A099C0CF104EF9183F374A54CA2576'
27
27
GRANT SELECT, INSERT ON `priv_db`.* TO 'test_noprivs'@'localhost'
28
 
connect(localhost,test_yesprivs,PWD,test,MASTER_MYPORT,MASTER_MYSOCK);
29
28
 
30
29
no trigger privilege on db level for create:
31
30
--------------------------------------------
33
32
create trigger trg1_1 before INSERT on t1 for each row
34
33
set new.f1 = 'trig 1_1-no';
35
34
ERROR 42000: TRIGGER command denied to user 'test_yesprivs'@'localhost' for table 't1'
36
 
connect(localhost,test_noprivs,PWD,test,MASTER_MYPORT,MASTER_MYSOCK);
37
35
use priv_db;
38
36
insert into t1 (f1) values ('insert-yes');
39
37
select f1 from t1 order by f1;
254
252
create User test_noprivs@localhost;
255
253
set password for test_noprivs@localhost = password('PWD');
256
254
revoke ALL PRIVILEGES, GRANT OPTION FROM test_noprivs@localhost;
257
 
connect(localhost,test_yesprivs,PWD,test,MASTER_MYPORT,MASTER_MYSOCK);
258
 
connect(localhost,test_noprivs,PWD,test,MASTER_MYPORT,MASTER_MYSOCK);
259
255
 
260
256
no trigger privilege on table level for create:
261
257
-----------------------------------------------
514
510
show grants for test_noprivs@localhost;
515
511
Grants for test_noprivs@localhost
516
512
GRANT SELECT, INSERT ON *.* TO 'test_noprivs'@'localhost' IDENTIFIED BY PASSWORD '*C49735D016A099C0CF104EF9183F374A54CA2576'
517
 
connect(localhost,test_yesprivs,PWD,test,MASTER_MYPORT,MASTER_MYSOCK);
518
 
connect(localhost,test_noprivs,PWD,test,MASTER_MYPORT,MASTER_MYSOCK);
519
513
select current_user;
520
514
current_user
521
515
test_yesprivs@localhost
564
558
show grants for test_yesprivs@localhost;
565
559
Grants for test_yesprivs@localhost
566
560
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'
567
 
connect(localhost,test_yesprivs,PWD,test,MASTER_MYPORT,MASTER_MYSOCK);
568
561
select current_user;
569
562
current_user
570
563
test_yesprivs@localhost
699
692
f1
700
693
insert-yes
701
694
insert-yes
702
 
connect(localhost,test_yesprivs,PWD,test,MASTER_MYPORT,MASTER_MYSOCK);
703
695
select current_user;
704
696
current_user
705
697
test_yesprivs@localhost
768
760
GRANT USAGE ON *.* TO 'test_noprivs'@'localhost' IDENTIFIED BY PASSWORD '*C49735D016A099C0CF104EF9183F374A54CA2576'
769
761
GRANT SELECT, INSERT, UPDATE ON `priv1_db`.* TO 'test_noprivs'@'localhost'
770
762
GRANT SELECT, INSERT ON `priv2_db`.* TO 'test_noprivs'@'localhost'
771
 
connect(localhost,test_yesprivs,PWD,test,MASTER_MYPORT,MASTER_MYSOCK);
772
763
use priv1_db;
773
 
connect(localhost,test_noprivs,PWD,test,MASTER_MYPORT,MASTER_MYSOCK);
774
764
use priv1_db;
775
765
 
776
766
trigger privilege on one db1 db level, not on db2
983
973
set password for test_useprivs@localhost = password('PWD');
984
974
revoke ALL PRIVILEGES, GRANT OPTION FROM test_yesprivs@localhost;
985
975
revoke ALL PRIVILEGES, GRANT OPTION FROM test_useprivs@localhost;
986
 
connect(localhost,test_yesprivs,PWD,test,MASTER_MYPORT,MASTER_MYSOCK);
987
976
select current_user;
988
977
current_user
989
978
root@localhost
1011
1000
f1
1012
1001
trig 1_1-yes
1013
1002
prepare ins1 from 'insert into t1 (f1) values (''insert2-no'')';
1014
 
connect(localhost,test_useprivs,PWD,test,MASTER_MYPORT,MASTER_MYSOCK);
1015
1003
select current_user;
1016
1004
current_user
1017
1005
test_useprivs@localhost
1207
1195
create User test_yesprivs@localhost;
1208
1196
set password for test_yesprivs@localhost = password('PWD');
1209
1197
revoke ALL PRIVILEGES, GRANT OPTION FROM test_yesprivs@localhost;
1210
 
connect(localhost,test_yesprivs,PWD,test,MASTER_MYPORT,MASTER_MYSOCK);
1211
1198
select current_user;
1212
1199
current_user
1213
1200
root@localhost
1319
1306
Grants for test_noprivs@localhost
1320
1307
GRANT USAGE ON *.* TO 'test_noprivs'@'localhost' IDENTIFIED BY PASSWORD '*C49735D016A099C0CF104EF9183F374A54CA2576'
1321
1308
GRANT SELECT, UPDATE ON `priv_db`.* TO 'test_noprivs'@'localhost'
1322
 
connect(localhost,test_yesprivs,PWD,test,MASTER_MYPORT,MASTER_MYSOCK);
1323
 
connect(localhost,test_noprivs,PWD,test,MASTER_MYPORT,MASTER_MYSOCK);
1324
1309
 
1325
1310
update only on column:
1326
1311
----------------------