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?

  • September 27, 2013 at 12:54 pm

    #1654173

    GilaMonster (9/27/2013)

    Grant those roles to the user, you can't afaik nest roles.

    Hi Gail,

    I'm confused, I'm sorry. I thought that the MSDN article that Bhuvnesh pointed to said that you could create custom roles and add fixed roles to them. I see you mean granting my new custom role to the user account I want to. But can I still add the db_datareader and db_datawriter roles to my custom roll? Or do I grant db_datareader/writer to my custom role?

    Kindest Regards, Rod Connect with me on LinkedIn.