One idea might be to create a view which contains only the records that each group is allowed to view, of course if you can't pin down the records with specific criteria it could be a pain manually determining which records should be included in each view.
Kola >> -----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]
