Re: Row based security

from Ronald R. Larson (rrl@ccd.harris.com) > > Does anyone know if Informix (or any commercial RDBMS for that mattter) > provides for access control (security) on a row basis? I use Informix Online > 4.1 with ESQL/C and ISQL ... as far as I can tell security is provided on > a database and table basis. I've heard about SQL2 providing further features > such as column selectable security (heard SYBASE has it now) but have not been > able to determine if security can be provided on a *row* basis. Is this > a planned future feature for SQL2? for INFORMIX? anywhere? The Informix standard products provide security on the database, table and column level. Informix Online/Secure, a special version of Informix for secure envirements provides security on the row level. A user cannot select, update, etc .. rows in a table that have a higher level of security then the user. The user can deal with rows on the same level as they are. The Informix 4.1 that you have, has database, table and column security. You can sort of do row level security with views. You would create a view of the rows you want a user to access, grant privileges to the view, and revoke the underlying table privileges. Regards - Lester ############################################################################# # Lester Knutsen lester@access.digex.net # # Advanced DataTools Corporation Voice: 703-256-0267 # # Providing Informix Database Tools and Consulting # #############################################################################