SQL · Theory

Grant Privilege

Theory

75/439

Grant Privilege

If you can teach Grant Privilege using Meera walking through Grant Privilege, you know it. If you only know the heading, you don’t.

For Grant Privilege, InnoDB is in play. Don’t blame it until you have traced Meera walking through Grant Privilege.

Grant Privilege exists so Meera can keep Meera walking through Grant Privilege correct in a small live site.

Grant Privilege shows up in a small live site. Name Meera walking through Grant Privilege, not “a real-world scenario”.

If Meera walking through Grant Privilege breaks under Grant Privilege, check only reciting the name of Grant Privilege first.

Grant Privilege is not a lonely heading. Meera ties it to Meera walking through Grant Privilege.

Viva for Grant Privilege: what it is → one Grant Privilege step Meera can write from memory → the mistake (only reciting the name of Grant Privilege).

Exam tip

For Grant Privilege: definition + a small live site + one failure.

Grant Privilege — sample query

-- Grant Privilege
CREATE TABLE demo (
  id INTEGER PRIMARY KEY,
  label TEXT NOT NULL,
  qty INTEGER DEFAULT 0
);
INSERT INTO demo (id, label, qty) VALUES
  (1, 'alpha', 2),
  (2, 'beta', 5);
SELECT label, qty FROM demo WHERE qty >= 2 ORDER BY qty DESC;

Grant Privilege: create two demo rows, then SELECT qty >= 2 ordered. Say which labels come back.

Short notes

DefGrant Privilege — Meera uses it for Meera walking through Grant Privilege in a small live site.
RuleGrant Privilege → one Grant Privilege step Meera can write from memory.
RememberGrant Privilege + InnoDB (a small live site).
UseGrant Privilege in a small live site (Meera walking through Grant Privilege).
TrapGrant Privilege — only reciting the name of Grant Privilege.
ExGrant Privilege → Meera walking through Grant Privilege.

-- Grant Privilege CREATE TABLE demo ( id INTEGER PRIMARY KEY, label TEXT NOT NULL, qty INTEGER DEFAULT 0 ); INSERT INTO demo (id, label, qty) VALUES (1, 'alpha', 2), (2, 'beta', 5); SELECT label, qty FROM demo WHERE qty >= 2 ORDER BY qty DESC;

Grant Privilege

Grant Privilege — sample query

Short notes

Questions

Grant Privilege

Grant Privilege — sample query

Short notes

Questions