Yasin Bilir Yasin Bilir - 3 months ago 11
SQL Question

Grant user to alter view and SP's but deny to create/drop user tables in sql

I would like to limit a user to create / drop user tables but this user needs to alter/view Stored procedures and views. Is there any way to manage both at the same time ?

When i make this user a member of ddladmin role, it can create / drop tables which i dont want.

Answer

Use the below script yo give view and alter permission to a user.

GRANT ALTER,VIEW DEFINITION ON SCHEMA::[YourSchema] TO [YourUser]
Comments