Deny Delete and Drop Permission

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

Questions by anjan_ashok

Showing Answers 1 - 1 of 1 Answers

lairdmcbride

  • Oct 22nd, 2008
 

USE [PARENTDB]
GO 
DROP SCHEMA [USER] GO USE [DB]
GO
DROP USER [USER]
GO

or 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 ..

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions