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

GRANT SELECT, INSERT, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, EVENT, TRIGGER ON `priv_db`.* TO 'test_noprivs'@'localhost'

225

use priv_db;

226

create trigger trg4b_1 before UPDATE on t1 for each row

247

drop trigger trg4b_1;

248

show grants;

249

Grants for test_yesprivs@localhost

250

GRANT TRIGGER ON *.* TO 'test_yesprivs'@'localhost' IDENTIFIED BY PASSWORD

250

GRANT TRIGGER ON *.* TO 'test_yesprivs'@'localhost' IDENTIFIED BY PASSWORD <secret>

251

GRANT UPDATE ON `priv_db`.* TO 'test_yesprivs'@'localhost'

252

use priv_db;

253

create trigger trg4b_2 before UPDATE on t1 for each row

292

GRANT UPDATE ON `priv_db`.`t1` TO 'test_yesprivs'@'localhost'

293

show grants;

294

Grants for test_noprivs@localhost

295

GRANT TRIGGER ON *.* TO 'test_noprivs'@'localhost' IDENTIFIED BY PASSWORD

295

GRANT TRIGGER ON *.* TO 'test_noprivs'@'localhost' IDENTIFIED BY PASSWORD <secret>

296

GRANT SELECT, INSERT, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER, CREATE VIEW, SHOW VIEW, TRIGGER ON `priv_db`.`t1` TO 'test_noprivs'@'localhost'

297

use priv_db;

298

create trigger trg4c_1 before INSERT on t1 for each row

311

drop trigger trg4c_1;

312

show grants;

313

Grants for test_yesprivs@localhost

314

GRANT TRIGGER ON *.* TO 'test_yesprivs'@'localhost' IDENTIFIED BY PASSWORD

314

GRANT TRIGGER ON *.* TO 'test_yesprivs'@'localhost' IDENTIFIED BY PASSWORD <secret>

315

GRANT UPDATE ON `priv_db`.`t1` TO 'test_yesprivs'@'localhost'

316

use priv_db;

317

create trigger trg4c_2 before INSERT on t1 for each row

345

GRANT TRIGGER ON *.* TO 'test_noprivs'@'%'

346

show grants;

347

Grants for test_noprivs@localhost

348

GRANT TRIGGER ON *.* TO 'test_noprivs'@'localhost' IDENTIFIED BY PASSWORD

348

GRANT TRIGGER ON *.* TO 'test_noprivs'@'localhost' IDENTIFIED BY PASSWORD <secret>

349

GRANT SELECT (f1), INSERT (f1) ON `priv_db`.`t1` TO 'test_noprivs'@'localhost'

350

use priv_db;

351

create trigger trg4d_1 before INSERT on t1 for each row

365

drop trigger trg4d_1;

366

show grants;

367

Grants for test_yesprivs@localhost

368

GRANT TRIGGER ON *.* TO 'test_yesprivs'@'localhost' IDENTIFIED BY PASSWORD

368

GRANT TRIGGER ON *.* TO 'test_yesprivs'@'localhost' IDENTIFIED BY PASSWORD <secret>

369

GRANT UPDATE (f1) ON `priv_db`.`t1` TO 'test_yesprivs'@'localhost'

370

use priv_db;

371

create trigger trg4d_2 before INSERT on t1 for each row

422

test_yesprivs@localhost

423

show grants;

424

Grants for test_yesprivs@localhost

425

GRANT SELECT, TRIGGER ON *.* TO 'test_yesprivs'@'localhost' IDENTIFIED BY PASSWORD

425

GRANT SELECT, TRIGGER ON *.* TO 'test_yesprivs'@'localhost' IDENTIFIED BY PASSWORD <secret>

426

create trigger trg5a_2 before INSERT on t1 for each row

427

set @test_var= new.f1;

428

set @test_var= 'before trig 3.5.3.8-2a';

454

GRANT SELECT ON `priv_db`.* TO 'test_yesprivs'@'localhost'

455

show grants;

456

Grants for test_noprivs@localhost

457

GRANT TRIGGER ON *.* TO 'test_noprivs'@'localhost' IDENTIFIED BY PASSWORD

457

GRANT TRIGGER ON *.* TO 'test_noprivs'@'localhost' IDENTIFIED BY PASSWORD <secret>

458

GRANT INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, EVENT, TRIGGER ON `priv_db`.* TO 'test_noprivs'@'localhost'

459

use priv_db;

460

create trigger trg5b_1 before UPDATE on t1 for each row

472

drop trigger trg5b_1;

473

show grants;

474

Grants for test_yesprivs@localhost

475

GRANT TRIGGER ON *.* TO 'test_yesprivs'@'localhost' IDENTIFIED BY PASSWORD

475

GRANT TRIGGER ON *.* TO 'test_yesprivs'@'localhost' IDENTIFIED BY PASSWORD <secret>

476

GRANT SELECT ON `priv_db`.* TO 'test_yesprivs'@'localhost'

477

use priv_db;

478

create trigger trg5b_2 before UPDATE on t1 for each row

507

GRANT SELECT ON `priv_db`.`t1` TO 'test_yesprivs'@'localhost'

508

show grants;

509

Grants for test_noprivs@localhost

510

GRANT TRIGGER ON *.* TO 'test_noprivs'@'localhost' IDENTIFIED BY PASSWORD

510

GRANT TRIGGER ON *.* TO 'test_noprivs'@'localhost' IDENTIFIED BY PASSWORD <secret>

511

GRANT INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER, CREATE VIEW, SHOW VIEW, TRIGGER ON `priv_db`.`t1` TO 'test_noprivs'@'localhost'

512

use priv_db;

513

create trigger trg5c_1 before INSERT on t1 for each row

521

drop trigger trg5c_1;

522

show grants;

523

Grants for test_yesprivs@localhost

524

GRANT TRIGGER ON *.* TO 'test_yesprivs'@'localhost' IDENTIFIED BY PASSWORD

524

GRANT TRIGGER ON *.* TO 'test_yesprivs'@'localhost' IDENTIFIED BY PASSWORD <secret>

525

GRANT SELECT ON `priv_db`.`t1` TO 'test_yesprivs'@'localhost'

526

use priv_db;

527

create trigger trg5c_2 before INSERT on t1 for each row

551

GRANT INSERT (f1), UPDATE (f1) ON `priv_db`.`t1` TO 'test_noprivs'@'localhost'

552

show grants;

553

Grants for test_noprivs@localhost

554

GRANT TRIGGER ON *.* TO 'test_noprivs'@'localhost' IDENTIFIED BY PASSWORD

554

GRANT TRIGGER ON *.* TO 'test_noprivs'@'localhost' IDENTIFIED BY PASSWORD <secret>

555

GRANT INSERT (f1), UPDATE (f1) ON `priv_db`.`t1` TO 'test_noprivs'@'localhost'

556

use priv_db;

557

create trigger trg5d_1 before INSERT on t1 for each row

565

drop trigger trg5d_1;

566

show grants;

567

Grants for test_yesprivs@localhost

568

GRANT TRIGGER ON *.* TO 'test_yesprivs'@'localhost' IDENTIFIED BY PASSWORD

568

GRANT TRIGGER ON *.* TO 'test_yesprivs'@'localhost' IDENTIFIED BY PASSWORD <secret>

569

GRANT SELECT (f1) ON `priv_db`.`t1` TO 'test_yesprivs'@'localhost'

570

use priv_db;

571

create trigger trg5d_2 before INSERT on t1 for each row

Older »