Re: READ ONLY DATABASE

sinyem@pc.jaring.my wrote: :Dear people, :Is this anything like read-only database, something like :GRANTing SELECT ON all TABLE(s) TO user_name or :GRANTing SELECT ON database_name TO user_name ? :I refering to granting view-only to *every* tables in a database to :a particular users. Granting select to each table would be tedious :since there could be lots and lots of tables in a database. :Product :------- :Informix-4GL 4.x :Informix-OnLine 4.x :Solutions and comments are greatly welcome. It is however easy to write a select statement selecting table names from systables and automatically creating the grant statements. Send the output to a file and execute the file. Something along these lines: select "grant select on ", tabname, " to username" from systables where tabid >99 You may have to create revoke statements first to revoke all from public. Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company The Informix FAQ is at http://www.iiug.org