Post reply

permission prob

  • June 30, 2009 at 11:08 pm

    #207699

    Hi Guys,

    i had giving some permission to users

    UPDATE,INSERT, DELETE which permission i had to given these guys,

    bulk admin or ddl admin could u please suggest me

    Thanks

  • June 30, 2009 at 11:18 pm

    #1018156

    shiv (6/30/2009)

    Hi Guys,

    i had giving some permission to users

    UPDATE,INSERT, DELETE which permission i had to given these guys,

    bulk admin or ddl admin could u please suggest me

    Thanks

    Not sure what you mean here, but if you needed to give individuals read and write permissions to all tables in a database, it would be db_reader and db_writer.

  • June 30, 2009 at 11:18 pm

    #1018155

    Probably not both

    Give datawriter role

    This is an article from this site.

    http://www.sqlservercentral.com/articles/Security/sqlserversecurityfixeddatabaseroles/1231/

    ----------------------------------------------------------------------------------------------------------------------------------------------------
    Roshan Joe

    Jeff Moden -Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • July 1, 2009 at 11:58 pm

    #1018911

    HI Roshan,

    Thank you for ur reply,

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

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