Home Forums SQL Server 2005 Administering What roles do I add to a new custom role, which will allow CRUD and execute on SP? RE: What roles do I add to a new custom role, which will allow CRUD and execute on SP?

  • Thank you, Gail, for your answer. Now I'm trying to work out the correct syntax. It looks as though I should use the GRANT statement. I've created a custom role called NormalUsers, and I'm trying to add the db_datareader role to NormalUsers. This was the syntax I used:

    GRANT db_datareader TO ROLE::NormalUsers TO AdventureWorks

    But that doesn't work. When I run the above statement I get this error:

    "Incorrect syntax near 'db_datareader'."

    What have I done wrong?

    Kindest Regards, Rod Connect with me on LinkedIn.