I can make a couple of suggestions based on past experience. I am assuming that you want to primarily limit 'which' files they are allowed to work with.
1) create a separate account (VOC) that only contains the files that they are allowed to work with. By limiting their login to that account only using OS level security you will effectively stop them from working with any other files. 2) Convert the account to an SQL schema. You can then attach file level security via the SQL user. Just remember to create a security entry for Public too otherwise you could end up locking out all the other users that are not subject to the tighter security. (i.e. GRANT ALL TO PUBLIC) If you are trying to allow them to access a file, but control what they do you may be out of luck. However you could use triggers to a least create audits. 3) Create your own wrapper api for Uniobjects. You could do this in VB or C++ fairly easily. Then give them your new library instead of the raw UniObjects dll. Of course this only works if you also restrict what they can install on their machines. Rich Taylor | Senior Programmer/Analyst| VERTIS 250 W. Pratt Street | Baltimore, MD 21201 P 410.361.8688 | F 410.528.0319 [EMAIL PROTECTED] | http://www.vertisinc.com Vertis is the premier provider of targeted advertising, media, and marketing services that drive consumers to marketers more effectively. "The more they complicate the plumbing the easier it is to stop up the drain" - Montgomery Scott NCC-1701 -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Kent Sent: Wednesday, May 25, 2005 8:37 PM To: [email protected] Subject: [U2] Uniobjects hack Does anyone have any suggestions on how to contain an advanced user from attaching the uniobjects control as a reference in excel and working out how to get access to the system. Uniobjects doesnt go in through a login paragraph. Thanks in advance jak ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
