SQL Server privilege

Question

User-1230161102 posted

Hi
How can I give a user in SQL Server 2017 the permission to execute procedures, select, update and insert to tables?

regards

Answer 1

User1535942433 posted

Hi itismesa,

As far as I think,the syntax for granting privileges on a table in SQL Server is:

GRANT SELECT, INSERT, UPDATE, DELETE ON employees TO smithj;

More details,you could refer to below article:

https://www.techonthenet.com/sql_server/grant_revoke.php

Best regards,

Yijing Sun