Re: Tables security
From: Tom Moreau (tom_at_dont.spam.me.cips.ca)
Date: 07/30/03
- Next message: lvthanh_at_hotmail.com: "security table in sqlserver 2000"
- Previous message: lvthanh_at_hotmail.com: "Tables security"
- In reply to: lvthanh_at_hotmail.com: "Tables security"
- Next in thread: Ray Higdon: "Tables security"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Wed, 30 Jul 2003 10:20:55 -0400
You could put a "do nothing" INSTEAD OF DELETE trigger on it:
create trigger trd_Customer on Customer instead of delete
as
return
go
-- Tom --------------------------------------------------------------- Thomas A. Moreau, BSc, PhD, MCSE, MCDBA SQL Server MVP Columnist, SQL Server Professional Toronto, ON Canada www.pinnaclepublishing.com/sql "Le Van Thanh" <lvthanh@hotmail.com> wrote in message news:eOb1QTqVDHA.1692@TK2MSFTNGP11.phx.gbl... Hi all, I created a table, this table's name is Customer, Fields are (CustomerID:nchar(10),CustomerName: Nchar(30)), in SQL Server. How way can lock this table, all users can not modify it. (if use Sql Server enterprise manager can not modifiy it). Thanks and Regards Thanh Le Van ********************************************************************** Sent via Fuzzy Software @ http://www.fuzzysoftware.com/ Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...
- Next message: lvthanh_at_hotmail.com: "security table in sqlserver 2000"
- Previous message: lvthanh_at_hotmail.com: "Tables security"
- In reply to: lvthanh_at_hotmail.com: "Tables security"
- Next in thread: Ray Higdon: "Tables security"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|