Home Forums SQL Server 2005 SQL Server 2005 Security execute procs,data read and data write permission for users RE: execute procs,data read and data write permission for users

  • January 31, 2011 at 6:24 am

    #1280374

    db_datareader, db_datawriter roles and then grant execute on the schema that the procedures are in. If it's the dbo schema, then...

    GRANT EXECUTE ON SCHEMA::dbo TO <username>

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass