~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'

226

use priv_db;

227

create trigger trg4b_1 before UPDATE on t1 for each row

248

drop trigger trg4b_1;

249

show grants;

250

Grants for test_yesprivs@localhost

251

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

251

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

252

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

253

use priv_db;

254

create trigger trg4b_2 before UPDATE on t1 for each row

293

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

294

show grants;

295

Grants for test_noprivs@localhost

296

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

296

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

297

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

298

use priv_db;

299

create trigger trg4c_1 before INSERT on t1 for each row

312

drop trigger trg4c_1;

313

show grants;

314

Grants for test_yesprivs@localhost

315

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

315

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

316

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

317

use priv_db;

318

create trigger trg4c_2 before INSERT on t1 for each row

346

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

347

show grants;

348

Grants for test_noprivs@localhost

349

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

349

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

350

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

351

use priv_db;

352

create trigger trg4d_1 before INSERT on t1 for each row

366

drop trigger trg4d_1;

367

show grants;

368

Grants for test_yesprivs@localhost

369

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

369

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

370

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

371

use priv_db;

372

create trigger trg4d_2 before INSERT on t1 for each row

423

test_yesprivs@localhost

424

show grants;

425

Grants for test_yesprivs@localhost

426

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

426

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

427

create trigger trg5a_2 before INSERT on t1 for each row

428

set @test_var= new.f1;

429

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

455

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

456

show grants;

457

Grants for test_noprivs@localhost

458

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

458

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

459

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'

460

use priv_db;

461

create trigger trg5b_1 before UPDATE on t1 for each row

473

drop trigger trg5b_1;

474

show grants;

475

Grants for test_yesprivs@localhost

476

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

476

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

477

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

478

use priv_db;

479

create trigger trg5b_2 before UPDATE on t1 for each row

508

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

509

show grants;

510

Grants for test_noprivs@localhost

511

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

511

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

512

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

513

use priv_db;

514

create trigger trg5c_1 before INSERT on t1 for each row

522

drop trigger trg5c_1;

523

show grants;

524

Grants for test_yesprivs@localhost

525

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

525

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

526

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

527

use priv_db;

528

create trigger trg5c_2 before INSERT on t1 for each row

552

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

553

show grants;

554

Grants for test_noprivs@localhost

555

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

555

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

556

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

557

use priv_db;

558

create trigger trg5d_1 before INSERT on t1 for each row

566

drop trigger trg5d_1;

567

show grants;

568

Grants for test_yesprivs@localhost

569

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

569

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

570

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

571

use priv_db;

572

create trigger trg5d_2 before INSERT on t1 for each row

Older »