or if you can determine what information groups can view through queries, how about making each query into a stored procedure and giving each group execute permissions only on their respective query.
> -----Original Message----- > From: Kola Oyedeji [mailto:[EMAIL PROTECTED] > Sent: 18 June 2003 14:58 > To: [EMAIL PROTECTED] > Subject: RE: [ cf-dev ] OT - SQL Server > > > 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] > -- ** 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]
