Hi,

What is the better way to create a read-only user in Informix.
This user must have only select permissions on Baan DB.

Hi,

Cann't you use ttaad4130m000 and put all packages and companies on READ permission?

GN

Hi,

we have such a user that can be used to read data from baan tables out of unix scripts and so on.

This can be achieved by a
grant select on <table> to <readonly user>; from within dbaccess, where <table> is e.g. ttiitm001<company> and <readonly user> is your read-only user.

The grant command must be done for *each* baan table (that should be accessible), but that can be automated as well:


select systables.tabname
from systables
where systables.owner = <baan-user> and not exists
( select *
from systabauth
where systabauth.tabid = systables.tabid
and systabauth.grantee = <readonly user>
and systabauth.tabauth = 's-------'
)

My Informix installed on NT machine.

I want the read-only user to be use with third-party software to access baandb to read data only.

Informix have role called baandbr and every DB user have that role.
If I'll grant the read-only user to all baandb tables I have to grant access to every new table and I don't want that.

I want to create a new role such baandbr that will have read-only access to baandb tables (include new tables created).

How can I create a new role with read-only access to all baandb tables?