Hello,

Please could anyone help me with this..I would like to create a new Informix account with read only access at the database level. Also set no access for the HR tables along with read only access to the other tables.

Thanks in advance.

Regards,

Adnan

Hello,

If you are trying to restrict user "informix", then I dont think it is possible. IF you want to create a new database user account with read only access, then you will first have to revoke all access from all the tables and database from public.Then grant access(select/insert/update/delete) to different users as per your discretion.

Nitin