RE: FW: Security and the ODBC
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------ =_NextPart_000_01BCBD26.CB84DBA0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit If you are going to continue this off-line, please keep me in the loop. I have been looking for a good solution to this exact problem for several years. Matter of fact, 3 years ago I started this same discussion in this news group and received the same basic answers with the exception that 'ROLEs' were not around back then--or if they were, they were not well known.. At some point, in the near future, I would really like to be able to diffuse this time-bomb as it *is* ticking (ie. ignorance of tools like MS Access is fading fast). My situation is somewhat more complicated than what has been described so far as the database contains around 500 tables (many we don't use--but even so...), 300+ applications and comes from an outside vendor with limited resources Does anyone know if Informix has officially addressed this issue, or has any plans to? -Todd tbernhardt@wii.com ---------- From: Dave Otto[SMTP:dotto@themoneystore.com] Sent: Tuesday, September 09, 1997 7:18 AM To: Tim Kelly; 'informix-list@rmy.emory.edu' Subject: Re: FW: Security and the ODBC You have raised a number of very valid points. These issues are what we have to deal with on a daily basis. So far we haven't hit upon "the universal sol'n". --clipped a great discussion-- The bottom line is that complex requirements rarely have trivial solutions. I deal with confidential financial information and have to address these types of issues every day. I would be very interested in continuing this discussion here or off-line. dave otto daveotto@acm.org ------ =_NextPart_000_01BCBD26.CB84DBA0 Content-Type: application/ms-tnef Content-Transfer-Encoding: base64 eJ8+IicUAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy b3NvZnQgTWFpbC5Ob3RlADEIAQmAAQAhAAAAQTRCMjc4NkZGMzI4RDExMUJENTAwMDgwNUZCQ0JE M0QAPgcBIIADAA4AAADNBwkACQANAC4AJAACAEcBAQWAAwAOAAAAzQcJAAkADQAsAAcAAgAoAQEN gAQAAgAAAAIAAgABBIABAB4AAABSRTogRlc6IFNlY3VyaXR5IGFuZCB0aGUgT0RCQwAsCQEDkAYA DAgAABgAAAADAC4AAAAAAEAAOQBguAUeYb28AR4AcAABAAAAHgAAAFJFOiBGVzogU2VjdXJpdHkg YW5kIHRoZSBPREJDAAAAAgFxAAEAAAAWAAAAAby9YR3tb3iypijzEdG9UACAX7y9PQAAAwAGENhE 1PIDAAcQ4QQAAB4ACBABAAAAZQAAAElGWU9VQVJFR09JTkdUT0NPTlRJTlVFVEhJU09GRi1MSU5F LFBMRUFTRUtFRVBNRUlOVEhFTE9PUElIQVZFQkVFTkxPT0tJTkdGT1JBR09PRFNPTFVUSU9OVE9U SElTRVhBQ1QAAAAAAwAQEAAAAAADABEQAAAAAAIBCRABAAAAlwUAAJMFAABVCQAATFpGdXwjSwD/ AAoBDwIVAqQD5AXrAoMAUBMDVAIAY2gKwHNldO4yBgAGwwKDMgPGBxMCg7ozEw19CoAIzwnZOxX/ eDI1NQKACoENsQtgbvBnMTAzFCALChLyDAGCYwBAIElmIHkIYEIgCsBlIGdvC4Bn8CB0byAFoAIw C4AKUCUb4GgEACBvDdAtbJELgGUsIAtQZWER8KQgawngcCAHgCALgIccoRtwFZBvcC4gGtBqIBHA dhtwYgnhHvJrNxuyAhAFwGEbgQRwIHM9BvB1HFACIBviHLNleJsA0AVAcANgAmBlbSCj+xHwH7By B0AbAB3AEeAfQfxNYQJABJAc8SCgIpEdgN4zJAQbQBuQH2FzAZAAIFMJgBykc2EeYWQEAGO+dQQQ IbIekxzRHWB3BCA/CcAIYB5AAHAhQBYAY2VeaR+wJtIbcCdDYh3Qaf5jKWED4ASQBCAD8BywHrM/ InAp0AUwIbMRwAVAJ1LgT0xFcycroASQG3B8bm8FQArACGApgSrQY+JrHrJuLS0FsQaQHrK+eS2j HYAvxy3zK2BsAyDiay4Ad24uC0YUIhp1di4KhQqFQQVAIWAeYXDfG6ElYR6VHWAKwWYhkAhwax1x H3B3CGBsKZIHQGz/L/AdQB4QG+If4BtAIwEb4r8nkA3QJ9AclRxQB4AtBuBPBtAbQAQgK8AgKgQA Kjc5MS7QG7IoCJAfQGln+y4AI9BuKdAk8hvwBvAEIPM3QwXhQWMp0AQRHNElMOcnkCCCHdB0KTM2 GW8adf0+hU0v8ACQNfAkoCgDJyG9NGF3LPIEYBthBaBtC1D/KwAkoCbDA5FCIxHABCAf4/8NsATy H+AhQiUhINE5IR7R/mQkoAGgHdIcIgtxJfEuVLg1MDAb4DfyBCAoA4F3L/IngAIgJwVAOLEvQGJf IZAiYB+wA6AhYC5KYCnrJXFH0CsbQHBC9CGxJfH/KYFCwQeRA1IpYRzwIZAAkH0NsCBKAUkABcAr sx1AbX8rwCbBFgAhYAhwPTEzTER+bweRSJECIB3xMbEvgkn2biCxTmB4RBMdASsABzH7NxE9wGRO wRHwJtUEAQpQfx2ABbFEIkiSC1EGMRvwP+kzTC1UBHBkPoUCUASRkRHBZHRAA/BpLkLBZzNMCvQd QDE4R9ACAGnwLTE0NA3wDNBaMwtZ/DE2PqADYCTAIqEvQFxWrz6HWwsMMFvWRgNhOl1eL1vWDIJQ IB+iTwJAb1tgU01UUDpJAGFxQHcewQRgHWB5JnBCgVgSXb9c/14NBmACMF8/YEtUClD6c0YweR2A BmAFMCMgV0EIIDA5HYAxOTk32CA3OlmwE3BNY49eDU9WgGXPZtwHcCBLMWF5vjstIAuAUZQdMSZw QFGwFHkuYoFyb5FkdSfjad9knnVialwRa/9gS+RSZXLARldywAZgJ8AdBRB0UtEpgR7CT0RC5kNY X1ljMzZa1zKFW9b+WRshH5Mj0AQAJsEg8Bxw72iDJQEjsS/wdgdATUA0lL0kUlQe0B3hU+NHMmU+ hf9CI0jRH5M4QjbhK6QhwSDw30YwAxAv8CrSJFJTRWR+Nb9JIT6FHMBJQTSgA6AiHsIfLnAp8RHg I+EhYSduIu8zPT9PGsAvQGMdQEsgekP/CcEtASeYXNdwXXiNfHEf0P9iEiMwHUI9cizjQsMicCmh +HF1aRYAB4B8EXnxFgD3NxF+ZAUQdgcxPoUhZiRS/x9wfugcIVJgDbAcQSPhUmD+bjuxkOJulEFU KXGBxn5191L1HrI4wnmGkBzifMYjov8v8GfhH0M2dDfBezI+hTTB/y3BJnAmwR6RHCUbsxzCJ5n/ HtAbYQWxHQYzPUYwH7FiEqebuWITANBtLgWwZzNMv3bvWtcaNVvWPoUVIQCiQAADADYAAAAAAAMA JgAAAAAAAgH5PwEAAAAeAAAAAAAAANynQMjAQhAatLkIACsv4YIBAAAAAAAAAC4AAAAeAPg/AQAA ABUAAABTeXN0ZW0gQWRtaW5pc3RyYXRvcgAAAAACAfs/AQAAAB4AAAAAAAAA3KdAyMBCEBq0uQgA Ky/hggEAAAAAAAAALgAAAB4A+j8BAAAAFQAAAFN5c3RlbSBBZG1pbmlzdHJhdG9yAAAAAEAABzAA JxmZWr28AUAACDBAwjt3Yb28AQMADTT9PwAAAgEUNAEAAAAQAAAAVJShwCl/EBulhwgAKyolFx4A PQABAAAABQAAAFJFOiAAAAAACwApAAAAAAALACMAAAAAAAIBfwABAAAATwAAADxjPVVTJWE9XyVw PVdpbGxhbWV0dGVfSW5kdXMlbD1XSUxMQU1FVFRFL0lTRE9NQUlOLzAwMDhBMjY5QHBkLWV4Y2gt MS53aWkuY29tPgAAUHg= ------ =_NextPart_000_01BCBD26.CB84DBA0--