Read-only role

ganga.dharan · #1 (**permalink**) 04-01-08, 07:50

Hi All,

Could you please let me know how do i identify which role has the read-only access. Basically, i need to provide read-only access to the users in the database, for which i need to identify the read only role in the informix database..

Thanks in advance..

ceinma · #2 (**permalink**) 04-03-08, 07:54

There is no easy way to do this...
You need check all grants from the role.

Code:

select * from systabauth order by grantee

Internet Services

Web Development

Digital Marketing

Consumer Tech