>>I want to have an SQL database that can be seen both internally to our corporate network and externally on the web.
to avoid hassle maybe create a separate database for public viewing on the web and seen internally, other database for private... colm -----Original Message----- From: Mark Smyth [mailto:[EMAIL PROTECTED] Sent: 18 June 2003 15:00 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] OT - SQL Server do they need to log in to view through coldfusion to view the data? -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 18 June 2003 14:49 To: [EMAIL PROTECTED] Subject: [ cf-dev ] OT - SQL Server Hi all, Is this possible or even the right way of doing it? If so how? I want to have an SQL database that can be seen both internally to our corporate network and externally on the web. The data consists of loads of tables where some of the data is for internal viewing only. This data isn't coneniently placed in seperate tables (another inherited database) and the sensitive data might be in several records across several tables..... So the idea is to create two accounts for the database one which will allow people to view sensitive data the other not. I thought that if I can tell the users IP address (or part of it) via coldfusion then I can log the person on as a particular user. Those with internal addresses get to see it all those without dont. Actually I have just been told that some of the data is only available to the privaled few in house as well. So there is a kind of teired account structure here... Does this make any sense at all? Regards - Paul ************************************************************* This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify [EMAIL PROTECTED] The views expressed within this email are those of the individual, and not necessarily those of the organisation ************************************************************* -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.489 / Virus Database: 288 - Release Date: 10/06/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.489 / Virus Database: 288 - Release Date: 10/06/2003 -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
