![]() Related Questions How to deny insert, update, delete, update permissions for a specific user of a specific user database? Latest Answer : So what context is the user in? A role a datareader? Datawriter?You want no permissions?USE Drop USER In a role?EXEC sp_droprolemember 'rolename' , 'Member'single objects?Revoke SELECT, ... How to deny delete and drop permission to the user for the particular database in SQL Server 2005. Latest Answer : 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 .. ... How can we dynamically assign parameters to a subscription in SQL Server Reporting Services 2005. If a table has more than one index, how will you call a specific index in query?
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||