Post reply

User Permissions Script

  • April 7, 2005 at 2:40 am

    #102469

    Hi All,

    I am looking for a script to permit Insert, Update and Delete on all user tables in my database.  Security is not an issue.  Cycle through User tables and grant those permissions.

    TIA

    Richard

     

  • April 7, 2005 at 7:17 am

    #551131

    grant datareader and datawriter to users/roles - no need to touch objects.  Or make them dbo < grin >

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • April 7, 2005 at 10:44 am

    #551231

    Colin,

    Thanks for the info - thats a great help to know when you're struggling to get to grips with the complexity of SQL. 

    Is there somewhere out there where the simple solutions and "need to know"'s on SQL are listed - it would save me and other Newbies the frustration of not knowing the simple things.

    Thanks again.

    Richard

     

     

     

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

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