Post reply

SQL 2005 - Read only access to user - DB and Jobs

  • December 28, 2010 at 7:13 am

    #231501

    Requirement:

    Users should be able to run select queries (i.e. read only access), monitor jobs (but not have access to run or modify jobs). How should I go about this?. I had tried giving SQLAgentUserRole, SQLAgentReaderRole, even SQLAgentOperatorRole; still that SQL id is not able to see jobs. It throws an error

    "EXECUTE permission denied on object 'xp_sqlagent_enum_jobs', database 'mssqlsystemresource', schema 'sys'. (Microsoft SQL Server, Error: 229)"

  • December 28, 2010 at 8:15 am

    #1266746

    If it is just select rights you want them to have, why not try setting those rights for a group at the schema level then put those users in that group?

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

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