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]
