How to deny delete and drop permission to the user for the particular database in SQL Server 2005.

lairdmcbride

 Profile Answers by lairdmcbride Questions by lairdmcbride

• Oct 22nd, 2008

USE [PARENTDB] GO DROP SCHEMA [USER] GO USE [DB]GO DROP USER [USER] GOor in GUI SQL SQL server Managment Studio go to your DB open it's security section up. . select users folder .. select user adn press delete on the keyboard ..

Answer Question  Select Best Answer