Grant Insert on a single table to all Logins

  • Is there a simple way to grant insert permission on a single table tbl1 in a database DB1 to all existing SQL Server Logins?

  • yes, use a database role and grant users access to the role

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • PMar (8/24/2011)


    Is there a simple way to grant insert permission on a single table tbl1 in a database DB1 to all existing SQL Server Logins?

    This seems like a homework question. The solution is very simple, if you have any familiarity with permissions.

    What role does every login in the server belong to? Once you've answered that, you'll know what to grant the insert permission to.


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA

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

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