创建用户，禁用所有权限

USE [master]
GO

IF EXISTS(SELECT * FROM sys.syslogins
WHERE name = N'mingyongchengDevUser')
DROP LOGIN [mingyongchengDevUser]
GO

CREATE LOGIN [mingyongchengDevUser] WITH PASSWORD=N'mingyongchengDevUser', DEFAULT_DATABASE=SRLS, CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
GO
USE SRLS
GO

IF EXISTS (SELECT * FROM sys.database_principals WHERE name = N'mingyongchengDevUser')
DROP USER [mingyongchengDevUser]
GO

CREATE USER [mingyongchengDevUser] FOR LOGIN [mingyongchengDevUser]
GO
USE SRLS
GO
EXEC sp_addrolemember N'db_owner', N'mingyongchengDevUser'
GO

   
--禁止用户查询所有的表
sp_msforeachtable 'deny SELECT ON ? TO test CASCADE '