SQLSERVER2022创建用户的图文教程

GRANT INSERT ON TableA TO RoleA      GO
EXEC sp_addrolemember RoleA, 'UserA'   GO 
-- 用户UserA将有TableA的INSERT权限
REVOKE INSERT ON TableA FROM RoleA   GO 
-- 用户UserA将不TableA的INSERT权限，发出权限。  
GRANT INSERT ON TableA TORoleA  GO 
--从新给RoleA以TableA的INSERT权限
DENY INSERT ON TableA TO UserA 
-- 固然用户UserA地点RoleA有TableA的INSERT权限，但UserA自己被DENY了，以是用户UserA将不TableA的INSERT权限。
批质增除了ms server数据表
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Create date: <二0两两.03.两3>
-- Description:    <批质增除了MsServer数据库外以F_末端的用户数据表>
-- =============================================
alter PROCEDURE BatchDeleteTable
AS
BEGIN
DECLARE @cul int 
declare @tablename varchar(50)
declare @dropSql nvarchar(100)
select @cul=COUNT(name) from sysobjects where (left(name,两) = 'F_')  and type='U'
print @cul
 
while @cul>0
  begin
    select @tablename=tb1.name from (select name from sysobjects where (left(name,两) = 'F_')  and (type='U')) as tb1
    set @dropSql='drop table'+' '+@tablename;
    EXECUTE sp_executesql @dropSql 
    select @cul=COUNT(name) from sysobjects where (left(name,两) = 'F_') and type='U'
end
 
END
GO