Multiple choice technology databases

Which of the following statements gives user desmond the ability to alter table gl.accounts?

  1. grant alter on gl.accounts to desmond;

  2. grant alter to desmond on gl.accounts;

  3. grant alter table to desmond;

  4. allow desmond to alter table gl.accounts;
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The standard SQL syntax for granting object privileges is GRANT ON TO ;. Option 539220 correctly follows this structure. Other options either misplace the 'ON' clause, use incorrect 'ALTER TABLE' syntax for a grant, or use non-standard 'ALLOW' keywords.

Keep practicing — related questions