Re: Basic Server Roles (security) question

From: Uri Dimant (urid_at_iscar.co.il)
Date: 01/09/05

  • Next message: Uri Dimant: "Re: Find Database Users" 
    Date: Sun, 9 Jan 2005 09:58:33 +0200

    cy
    Are you member of sysadmin server role as well?

    "cy" <cyrus.kapadia@us.pm.com> wrote in message
    news:1105036907.387257.286720@f14g2000cwb.googlegroups.com...
    > I want to add a consulting firm of ours to have full access to a
    > database on my SQL 2000 SP3 server (so DBOWNER is ok with me).
    >
    >
    > But I also need them to be able to schedule a job against that database
    > AND create various DB maintenance plans. I've scoured the BOL but
    > nothing I can find talks about this kind of granularity in security.
    > Is there a role that will allow this?
    >
    >
    > Many thanks.
    >

  • Next message: Uri Dimant: "Re: Find Database Users"

    Relevant Pages