Post reply

Select from system object from the msdb database

  • May 6, 2004 at 12:49 am

    #160866

     Hello,

    I'm a newbie. One of our developers needs to "Select from system objects in the msdb database". Would this be secure or should I not give him access?

    Thanks in advance for your help,

    Lawrence

  • May 6, 2004 at 2:22 am

    #505422

    ask him what he needs it for.

    it's more than likely he'll be checking for the existence of a stored procedure or table. either give him read only access (once you've decided) or look up the INFORMATION_SCHEMA views and point him in that direction

    cheers

    dbgeezer

  • May 6, 2004 at 9:04 am

    #505496

    The developer is a trusted source. He needs to create/schedule

    jobs. If I gave him read only would that be secure enough?

     

    Thanks,

    Lawrence

     

  • May 6, 2004 at 9:14 am

    #505497

    i don't know what do you think ?

    you could limit him futher to just the sysjobs(*) tables ...

    cheers

    dbgeezer

  • May 6, 2004 at 10:21 am

    #505519

    Thanks, If I just give him Select rights to sysjobs and sysjobsschedules tables that is still secure right?

     

  • May 7, 2004 at 1:54 am

    #505606

    Whether it's secure or not is entirely your decision. You're the DBA. Select permission will stop him from screwing anything up but will more than likely show him things he doesn't need to see.

    cheers

    dbgeezer

  • May 7, 2004 at 10:05 am

    #505683

    Thanks for the help dbgeezer. I just gave him select to sysjobs and sysjobsschedules.

    Lawrence

Viewing 7 posts - 1 through 6 (of 6 total)

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