Re: READ ONLY DATABASE

Dear Person, >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 ? [...] There's nothing quite like that. In later versions of OnLine there are roles, which help. You could also directly affect the permissions table, but you stand to make a terrible mess unless you do it just right. Your best bet is to make a short script to automate the process. It is only a few minute's work to write a shell which | GRANT statements to dbaccess, reading from a file or the command line. Hint: have your script build a list of all user tables with something like this: SELECT tabname FROM systables WHERE tabid > 99 You may search the c.d.i. archives for old shells that have been posted. Good luck, ______________________________________________________ Clem Akins (aka clema@informix.com) Informix Software, Inc (Standard disclaimers apply) International Technical Support Last seen: Spending a balmy winter in Singapore!