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.
Use the below script yo give view and alter permission to a user.
GRANT ALTER,VIEW DEFINITION ON SCHEMA::[YourSchema] TO [YourUser]