• Create a user-defined database role for the appropriate database. You can do so in Enterprise Manager or through Query Analyzer. If using QA, you'll want to execute the following (make sure you are in the correct database):

    EXEC sp_addrole 'rolename'

    As far as granting that role the correct permissions, the easiest way to do so is using QA:

    GRANT CREATE VIEW TO [rolename]

    You can then add users to the role in order to give them the ability to create views. This does not allow them to create tables.

    K. Brian Kelley
    @kbriankelley