CODEWITHSUNDEEP
sql-serversql-server-2012
ChaseHardin
ChaseHardin

Reputation: 2269

Grant all privileges on two tables to one user

I have searched the web, but can't find anything that addresses this question. I want to give all privileges on two different tables to a user. Can this be done? This is what I have.

GRANT ALL PRIVILEGES 
    ON TABLE SALES, PRODUCT
    TO FRED

Thanks!

Upvotes: 1

Views: 381

Answers (1)

Mureinik
Mureinik

Reputation: 312219

The grant syntax handles one table at a time. Also, there is no "table" after the "on":

GRANT ALL PRIVILEGES ON SALES TO FRED;
GRANT ALL PRIVILEGES ON PRODUCT TO FRED;

Upvotes: 2

Related Questions