We help IT Professionals succeed at work.

Is it possible to grant different permissions to multiple tables for the same user in one statement?

NevSoFly
NevSoFly asked
on
Below code that I used to grant the Insert permission:
 
"USE COFSE; GRANT INSERT ON tblUserInfo TO [218009094]"

My question is can I grant different permissions to multiple tables for the same user in one statement,
and if so what is the syntax?
Comment
Watch Question

Billing Engineer
CERTIFIED EXPERT
Most Valuable Expert 2014
Top Expert 2009
Commented:

Explore More ContentExplore courses, solutions, and other research materials related to this topic.