if it's on a row-by-row basis, you need to add a Permission column on the tables, and set it for each row of data.
Duncan Cumming IT Manager http://www.alienationdesign.co.uk mailto:[EMAIL PROTECTED] Tel: 0141 575 9700 Fax: 0141 575 9600 Creative solutions in a technical world ---------------------------------------------------------------------- Get your domain names online from: http://www.alienationdomains.co.uk Reseller options available! ---------------------------------------------------------------------- ---------------------------------------------------------------------- [EMAIL PROTECTED] ham.gov.uk To: [EMAIL PROTECTED] cc: 18/06/2003 14:49 Subject: [ cf-dev ] OT - SQL Server Please respond to dev 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]
