Re: Security Programs
Hi James, > I've been given the wonderful task of security > implementation on a warehouse we're putting together here. Users will > access it via PC's and a few will have telnet access. We have two > instances 1)8.10.UD1 - The warehouse 2)7.20 - Marketing Mart. > Using roles on the mart is out of the question because we cannot > expect our users to be able to execute the "set role" command before > submitting queries. I need to control access at the table level. I'm > looking for a simple security program using 4gl or ESQL-C is this > available in the archives? I don't want to go through the hassle of > duplicating this if I can leverage work already done. Does anyone > know of any third part software for doing this that will run on XPS? This sounds like a description of DB Privileges, a dba tool I developed to make it easier to control privileges. Its written in 4GL and a 30 day RDS evaluation copy is available so you can try it out. Attached is a short description from the Informix Solutions Guide. Please let me know if you would like for information. Regards - Lester ---------------------------------------------------------------------- Product Name: DB Privileges Product Description: DB Privileges is an interface to Informix database privileges. It allows a database administrator to quickly change user database, table or column permissions on a data entry screen without any programming. DB Privileges is easy enough for a non technical security officer to maintain database privileges. DB Privileges is the first product that allows a database administrator to create and manage groups of users with common Informix database permissions. Add a user to a group and the user instantly inherits all the group database permissions. Remove a user and all their privileges will be automatically revoked. Cost: $995 per Database Server Company: Advanced DataTools Corporation 4510 Maxfield Drive Annandale, VA 22003, USA Contact: Lester Knutsen 703-256-0267 ############################################################################# # Lester Knutsen lester@access.digex.net # # Advanced DataTools Corporation Voice: 703-256-0267 # # Grant group privileges for Informix databases with DB Privileges # # Visit our Web page: http://www.access.digex.net/~lester # # Washington Area Informix User Group: http://www.access.digex.net/~waiug # #############################################################################