Locking Columns

[seekwall]

Without using security controls, how can I 'lock' certain columns on a table - from being deleted or updated ?

I can't work out a way of using triggers or constraints to do this.

Can anyone help ?

 

[tlbroadbent]

What do you mean "Without using security controls?" You must use some measure of security to prevent updating of columns.

If you are using SQL 7 or 2000, look in SQL Books Online under GRANT and DENY. You can grant or deny permissions on columns. You can also use Enterprise Manager to set column permissions. However, you grant or deny permissions to users so you'll be using a security context. Perhaps, you'll want to deny update permissions on the column to the Public role. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.