Re: database privileges

> We have a need to do some individual table privileges in our system > and it's getting very tedious using SQL. So, before I go about > trying to re-invent the wheel, I thought that someone might have > already developed some 4GL code that will GRANT or REVOKE > specified table privileges for individuals. If so, I would be > forever grateful as it would undoubtedly save me much time and > energy (neither of which I have much of :-) > > Keith Howard > Service Systems Enterprises > > Keith, We have a product call DB Privileges that allows you to grant and revoke privileges to users and to a group of users.The following is a brief description. We have an RDS 30 day demo program available. Please send email with your mailing address and I will send you more information. ############################################################################# 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. ############################################################################# # Lester Knutsen lester@access.digex.net # # Advanced DataTools Corporation Voice: 703-256-0267 # # Grant group privileges for Informix databases with DB Privileges # #############################################################################