Re: granting select only priviledges

using dbaccess, run the following: select "grant select on", tabname, "to <user>;" from <database>:systables where owner <> "informix"; Save the output to a file, run the file. Just make sure you save the output to a file with sql as an extension so dbaccess will see it. (You do have to remove the first line though) dcaylor@maf.org wrote: : I need to grant select priveleges (and no other) to one user on a database : with thousands of tables. Informix tech support told me to grant connect, : then revoke all, then grant select to the specific tables I need. This would : work, except that in order to revoke all, you have to specifify tables by : name. It won't accept no table name, and it won't accept *. : How do I grant select rights for a user to specific tables without having to : name all the tables in the database? I can't believe that anyone would make a : database without allowing you to do so. : -----------== Posted via Deja News, The Discussion Network ==---------- : http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own -- Rob Wilson rwilson@informix.com