I've table and data as following,CREATE TABLE [dbo].[acctInfo]( [idx] [int] IDENTITY(1,1) NOT NULL, [myID] [varchar](20) NOT NULL, [pwd] [varchar](100) NOT NULL, [fullNme] [varchar](50) NOT NULL, [daerahKutipan] [int] NOT NULL, [allowReceiptBackDated] [bit] NULL, [allowCheckedByOnOffcReceiptManagement] [bit] NULL, [acctStat] [int] NOT NULL, [crtBy] [varchar](20) NULL, [crtDte] [datetime] NULL, [updBy] [varchar](20) NULL, [updDte] [datetime] NULL, CONSTRAINT [PK_acctInfo] PRIMARY KEY CLUSTERED ( [idx] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY], CONSTRAINT [acctInfo_UQ1] UNIQUE NONCLUSTERED ( [myID] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]GOSET IDENTITY_INSERT [dbo].[acctInfo] ONINSERT [dbo].[acctInfo] ([idx], [myID], [pwd], [fullNme], [daerahKutipan], [allowReceiptBackDated], [allowCheckedByOnOffcReceiptManagement], [acctStat], [crtBy], [crtDte], [updBy], [updDte]) VALUES (1, N'sysownr', N'1925', N'Mohd Zailani Yunus', 1, 1, 1, 1, N'sysowner', CAST(0x00009F2C00000000 AS DateTime), N'sysowner', CAST(0x00009F2C00000000 AS DateTime))SET IDENTITY_INSERT [dbo].[acctInfo] OFF
sysownr is a root account. how to prevent sysownr to be deleted by the database user? if possibe, please let me know. if can't, please let me know the other way
how to prevent row is deleted?
Posted - 2011-08-15 : 00:36:19
