2012年2月9日星期四

Basic Server Roles (security) question

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.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.
>|||Yes, I am top dog on the server - I have all keys to all kingdoms. But
they aren't, of course.
Cy.
Uri Dimant wrote:[vbcol=seagreen]
> 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...
database[vbcol=seagreen]
security.[vbcol=seagreen]

没有评论:

发表评论