Is there anyway to revoke the drop table permison from DBO

  • For our current system, some accounts need to have DBO permission to do certain thing, is it possible to revoke the drop table permission for DBO or SA owner?

    Thanks,

    Minh Vu

  • What permission do these accounts need to have which is restricted only to dbo?

  • they should have everything except 'Drop table'

    Thanks,

    Minh Vu

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

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