Re: NEWERA -- Database Security

Brian Hampson wrote: > > Allan Gould (allang@sco.com_no-junkmail-please) wrote: > > : Brian Hampson wrote: > > : Firstly, I thought Informix NewEra was Informix's client server toolkit, > : so it wouldn't appear that you need ODBC to connect anyway .... > > This would be good, if there was some sort of thing in a New-Era Compiled > application, that would identify it so, and the DB then would talk > happily, without having to make a host, a "Unix trusted host"...(Can YOU > trust your PC's?) I'm a bit out of my depth with NewEra: I'd think it would be safest to talk to Informix to get the precise story on that one. > : In answer to your question on ODBC security, there is no mention of the > : security that you envisage in the ODBC standard itself, but some vendors > : have added it for the very reason you specify above. You could take a > : look at our ODBC driver ("SCO SQL-Retriever"). This would allow you to > : filter ODBC access by table, user id, SQL, etc., but most importantly in > : your case by application (e.g. Access, Excel, VB). Take a look at > : http://www.vision.sco.com/products/sqlretriever/ for more info and a > : downloadable eval > > This sounds interesting. Thanks for the follow-up. I'm new to this whole > ODBC concept, etc. Are the drivers run on the HOST, AND the client (I > would hope so, otherwise anyone could run any client ODBC, and then I'm > back to square one) There is a Unix-based component (an rpc-listening demon process) and a PC-based compoent (essentially a couple of DLLs). The crux of the security mechanism lies on the host in a text file which specifies the security "rules" so it applies to all PCs using ODBC to a given RDBMS on a given machine. > B. > -- > If you're local to me, ask me about the Scout popcorn fundraising drive! I don't think I could be much further away ....! > Brian P. Hampson ASL Analytical Service Laboratories Ltd > System Administrator, Vancouver, BC (604)253-4188 > ----------------- http://www.asl-labs.bc.ca/ ---------------------------- > > These opinions are MINE I tell you ....all mine!!! (nobody else wants them)