Re: ODBC & Client Access

Ray Riley wrote: > > I've read on this Newsgroup somebody mentioning a product/technique called > "Roles," but I haven't been able to find any reference to it elsewhere, but it is > supposed to help manage grants etc. Has anyone heard of, or have any info on this? You still need to grant & revoke permissions at the database and table level. Roles are available in 7.10.UD1 onwards I think. These are simply an extension to grant & revoke, whereby you can create a role name and grant permissions to that role. You can then allow users to assume a particular 'role' and assume the permissions of that role. > I researched SPLs and triggers, but there doesn't seem to be a trigger event for users > connecting to the database. I could enforce access to be read-only if I were to trap > Insert Updates and Deletes, but I would really like to be able to monitor connections > to the database as well. I think you should look at secure auditing. This is not an audit trail in the traditional sense, but rather the ability to monitor certain actions on your system. For instance you can monitor certain users every time they connect to a database. > All this runs under INFORMIX Online 5.x and Intersolv's DataDirect SequeLink. Any help > would be appreciated on this issue, post or direct e-mail. If you are still running 5.xx then look at upgrading to 7.1x. Cheers, -- Mark. +-------------------------------------------------------------------------+ |Mark D. Stock - The West Solutions Group http://www.west.co.za | | | |mailto:marks@west.co.za +------------------------------------------------+ |Tel: +27 11 803 2151 |If it doesn't work... force it! | |Fax: +27 11 803 2189 |If it breaks... it needed replacing anyway! | |Cell: +27 83 250 2325 |Well, that's how I code anyway! | +------------------------+------------------------------------------------+