Grant Create View but not Tables

I have a role called "Developer" in my SQL database. Currently users in that role can create stored procedures but not tables. I'd like them to be able to create and edit views as well but still not tables. How can I do this?
LVL 21
Russ SuterAsked:
Who is Participating?
ste5anSenior DeveloperCommented:
Requires CREATE VIEW permission in the database and ALTER permission on the schema in which the view is being created.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.