无法向Sql Server 2005表添加权限

这些是我正在执行的命令:
USE [Messenger];
GO
GRANT DELETE ON [dbo].[Messages] TO [MM_TableAccess];
GO
GRANT INSERT ON [dbo].[Messages] TO [MM_TableAccess];
GO
GRANT SELECT ON [dbo].[Messages] TO [MM_TableAccess];
GO
GRANT UPDATE ON [dbo].[Messages] TO [MM_TableAccess];
GO
MM_TableAccess是一个角色。 Toad告诉我这些命令已成功执行。 执行此操作后,当我查看表上的权限时,它显示无;查看启用了“权限”的创建脚本显示没有授权命令。 我试着刷新桌子;关闭蟾蜍并再次重新开放;重新启动。什么都行不通。这是数据库中唯一的表(只有6个表)我无法添加这些权限。 这是我的表创建脚本:
USE [Messenger];
GO
SET ANSI_NULLS ON;
GO
SET QUOTED_IDENTIFIER ON;
GO
CREATE TABLE [dbo].[Messages] (
[MessageID] bigint IDENTITY(1, 1) NOT NULL,
[ParentID] bigint NOT NULL,
[CategoryID] bigint NOT NULL,
[PostedByID] bigint NOT NULL,
[DatePosted] datetime NOT NULL,
[MessageTitle] nvarchar(50) NULL,
[MessageBody] nvarchar(4000) NOT NULL,
CONSTRAINT [PK__Messages__07F6335A]
PRIMARY KEY NONCLUSTERED ([MessageID] ASC)
WITH ( PAD_INDEX = OFF,
FILLFACTOR = 100,
IGNORE_DUP_KEY = OFF,
STATISTICS_NORECOMPUTE = OFF,
ALLOW_ROW_LOCKS = ON,
ALLOW_PAGE_LOCKS = ON )
ON [PRIMARY],
CONSTRAINT [FK_ParentID]
FOREIGN KEY ([ParentID])
REFERENCES [dbo].[Messages] ( [MessageID] ),
CONSTRAINT [FK_CategoryID]
FOREIGN KEY ([CategoryID])
REFERENCES [dbo].[Categories] ( [CategoryID] )
ON DELETE CASCADE

)
ON [PRIMARY];
GO
我在Windows XP SP3上使用SQL 2005 SP4。 会发生什么事?     
已邀请:

要回复问题请先登录注册