Post reply

Create and Alter Views permissions?

  • September 25, 2019 at 6:26 pm

    #3683409

    Is there a convenient way to give a user permissions to create and alter views without allowing them to destroy the tables in a database?

    That would be convenient.

    When the snows fall and the white winds blow,The lone wolf dies but the pack survives.

    Once you've accepted your flaws, no one can use them against you.

  • September 25, 2019 at 7:28 pm

    #3683424

    not to that level of granularity, but there is a way to code around that.

    take a look at this post from a while back where i posted a complete solution using a Database DDL trigger to rollback any ALTER TABLE permissions, but leaving the user just with CREATE_VIEW or ALTER_VIEW permissions.

     

    https://www.sqlservercentral.com/forums/topic/create-user-role-grant-permission

     

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply