← 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/ndb_storedproc_06.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/ndb_storedproc_06.result
78
78
revoke create routine on db_storedproc_1.* from 'user_1'@'localhost';
79
79
flush privileges;
80
80
DROP PROCEDURE IF EXISTS sp1;
81
 
connect(localhost,user_1,,db_storedproc_1,MYSQL_PORT,MYSQL_SOCK);
82
81
        
83
82
user_1@localhost        db_storedproc_1
84
83
USE db_storedproc_1;
91
90
        
92
91
root@localhost  db_storedproc_1
93
92
GRANT CREATE ROUTINE ON db_storedproc_1.* TO 'user_1'@'localhost';
94
 
connect(localhost,user_1,,db_storedproc_1,MYSQL_PORT,MYSQL_SOCK);
95
93
        
96
94
user_1@localhost        db_storedproc_1
97
95
USE db_storedproc_1;
112
110
--------------------------------------------------------------------------------
113
111
grant create routine on db_storedproc_1.* to 'user_1'@'localhost';
114
112
flush privileges;
115
 
connect(localhost,user_1,,db_storedproc_1,MYSQL_PORT,MYSQL_SOCK);
116
113
        
117
114
user_1@localhost        db_storedproc_1
118
115
DROP PROCEDURE IF EXISTS sp3;
149
146
BEGIN
150
147
SELECT * from db_storedproc_1.t6 where t6.f2= 'xyz';
151
148
END//
152
 
connect(localhost,user_1,,db_storedproc_1,MYSQL_PORT,MYSQL_SOCK);
153
149
        
154
150
user_1@localhost        db_storedproc_1
155
151
USE db_storedproc_1;
191
187
grant SELECT on db_storedproc_1.* to 'user_2'@'localhost';
192
188
grant execute on db_storedproc_1.* to 'user_2'@'localhost';
193
189
flush privileges;
194
 
connect(localhost,user_1,,db_storedproc_1,MYSQL_PORT,MYSQL_SOCK);
195
190
        
196
191
user_1@localhost        db_storedproc_1
197
192
CREATE PROCEDURE sp5_s_i () sql security definer
207
202
BEGIN
208
203
insert into db_storedproc_1.t3165 values ('inserted', 'from sp5_ins', 1000);
209
204
END//
210
 
connect(localhost,user_2,,db_storedproc_1,MYSQL_PORT,MYSQL_SOCK);
211
205
        
212
206
user_2@localhost        db_storedproc_1
213
207
CALL sp5_s_i();
305
299
GRANT SELECT  ON db_storedproc_1.* TO 'user_2'@'localhost';
306
300
GRANT EXECUTE ON db_storedproc_1.* TO 'user_2'@'localhost';
307
301
FLUSH PRIVILEGES;
308
 
connect(localhost,user_1,,db_storedproc_1,MYSQL_PORT,MYSQL_SOCK);
309
302
        
310
303
user_1@localhost        db_storedproc_1
311
304
CREATE PROCEDURE sp3166_s_i () SQL SECURITY INVOKER
321
314
BEGIN
322
315
insert into db_storedproc_1.t3166 values ('inserted from sp3166_ins');
323
316
END//
324
 
connect(localhost,user_2,,db_storedproc_1,MYSQL_PORT,MYSQL_SOCK);
325
317
        
326
318
user_2@localhost        db_storedproc_1
327
319
CALL sp3166_s_i();
340
332
inserted outside SP
341
333
GRANT INSERT  ON db_storedproc_1.* TO 'user_2'@'localhost';
342
334
FLUSH PRIVILEGES;
343
 
connect(localhost,user_2,,db_storedproc_1,MYSQL_PORT,MYSQL_SOCK);
344
335
        
345
336
user_2@localhost        db_storedproc_1
346
337
CALL sp3166_s_i();
361
352
inserted from sp3166_ins
362
353
REVOKE SELECT ON db_storedproc_1.* FROM 'user_2'@'localhost';
363
354
FLUSH PRIVILEGES;
364
 
connect(localhost,user_2,,db_storedproc_1,MYSQL_PORT,MYSQL_SOCK);
365
355
        
366
356
user_2@localhost        db_storedproc_1
367
357
CALL sp3166_s_i();
379
369
root@localhost  db_storedproc_1
380
370
REVOKE EXECUTE on db_storedproc_1.* FROM 'user_2'@'localhost';
381
371
FLUSH PRIVILEGES;
382
 
connect(localhost,user_2,,db_storedproc_1,MYSQL_PORT,MYSQL_SOCK);
383
372
        
384
373
user_2@localhost        db_storedproc_1
385
374
CALL sp3166_s_i();