Re: Re: web datablade and security

On Wed, 17 Mar 1999 04:20:27 -0600 (CST), you emitted: >>As a matter of fact I opted to register the web datablade for three >>databases and filled each one with the apb pages. >>Then, i created a "ln -s" link to the "webdriver"to each usergroup >>account's cgi directory and set up a different >>web.cnf for each linked webdriver to access its respective database..... Sounds like the best bet. >>I think it is as secure as enough... but is it the fairest? Consider data >>duplication on apb pages !!!! Actually, if data is going to be duplicated (as in HTML code) then that is what the dynamic tags are for. Anything that you are going to use more than once should go in a dynamic tag. For example, javascript code that you will possibly duplicate on more than one page, put it in a tag. Any HTML that might appear on more than one page, put it in a tag. It's easy enough to copy the dynamic tags between databases. You can write SQL to keep the tags in sync. If the data that is to be duplicated is actual data (from SQL selects and such) then that is no problem either since you can select from any database or table that the user defined in the web.cnf has privileges on (SELECT c.id, d.id FROM DBNAME1@DBSERVER:yourtable c). So all the same data can be made available to any of your three DBs. Tony