<div>
<div class="content wysiwyg-content">
Below code that I used to grant the Insert permission:<br />
&nbsp;<br />
&quot;USE COFSE; GRANT INSERT ON tblUserInfo TO [218009094]&quot;<br />
<br />
My question is can I grant different permissions to multiple tables for the same user in one statement,<br />
and if so what is the syntax?
</div>
</div>


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?

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

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.