Chapter 3 PHYSICAL DATABASE DESIGN AND IMPLEMENTATION 151
Chapter 3 PHYSICAL DATABASE DESIGN AND IMPLEMENTATION 151 An alternative to creating a view would be to handle column-level permissions over a table, which can be a true nightmare to administer. A new interface feature in SQL 2000 does enable you to use the GUI to set column-level permissions. However, this feature should be used as little as possible if ever. (See Figures 3.8, 3.9, and 3.10 for column permission availability.) In previous releases, you could set column permissions, but only through the use of T-SQL commands. These illustrations shows that the GUI representations for column permissions are significantly different from standard permissions and thus stand out if they are set. FIGURE 3.8 Command button now available on the interface to set column-level permissions. FIGURE 3.9 Column Permissions dialog box, available from the GUI.
For high quality website hosting services please check java web hosting website.