From: Andy C. <an...@ad...> - 2001-03-14 11:39:51
|
FYI, I gave up on the TABLE / VIEW dichotomy and simply added a TAG = column to each of my basic tables. For each table, granted SELECT & = REFERENCES to PUBLIC, granted ALL to whichever program maintains the = contents of that table. The agony of TABLE/VIEW was that the code that = reads the records had to read them from the table if it was running as = part of one application and from the view if it in a different = application. The number of columns changed, etc. Affected virtually = every table in the database. So I'll just let people see the "TAG" = column and tell them to ignore it. Thanks for the help. |