Home Forums SQL Server 2005 SQL Server 2005 Security Deny delete and drop permission to the sql user RE: Deny delete and drop permission to the sql user

  • October 1, 2012 at 1:02 pm

    #1544100

    Hi, i have similar problem sometime ago. I have a user that need to be dbo for some reason but i neet to limited to "no drop".

    i found the solution using DENY ALTER ON SCHEMA::[dbo] to [someuser]