SQL Server Administration - User/Login Admin

Grant Database Access

Revoke a SQL Server Login. Note Microsoft states that this stored procedure will be deprecated and replaced by "Drop User"

Syntax - SQL Server 2005/2008

sp_revokedbaccess [ @name_in_db = ] 'name'
GO

--returns 0=ok 1=failed

Example - SQL Server 2005/2008

EXEC sp_revokedbaccess  'SEASVR\ericm', 'ericm'
GO

 Collapse All    Expand All

• 2005/2008 User Admin
  • Add Sql Server Login
  • Drop Sql Server Login
  • Add User to Database Role
  • Drop User to Database Role
  • Add Login to Server Role
  • Drop Login to Server Role
  • Add Linked Server Login
  • Drop Linked Server Login
  • Grant Login
  • Revoke Login
  • Grant DB Access
  • Revoke DB Access

SQL Server Information and Resources