Grant Option

Hey guys! I'm a little stymied here. I need to be able to grant SELECT privileges only on all the tables in a database to certain users. I've written a little (isqlperl) script to do this, but cannot cleanly GRANT SELECT on all tables (even as Informix), since the tables were created by different people. I get the error message: 302: No Grant option or illegal option on multi-table view (its definitely not a multi-table view) It appears I would have to become to creator of each table, and user the "WITH GRANT OPTION" to accomplish such a feat. I must be missing something. As informix, or a user with DBA, how may I GRANT SELECT table by table without becoming the explicit owner of each table? Shouldnt the DBA be able to do anything? While we are on this subject, can someone explain dbaccess and its features to me? Maybe that will be a better solution. Naomi -- Naomi Walker (aka N7FSA) naomi@anasazi.com Phoenix, Arizona The best things in life aren't things.