Re: 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. > > > Grant privilege........ AS owner; > > will do it. > Thanks you for all your responses to my dilemna. It still stands. Our production databases have had tables dropped and recreated my various people (our DBA's). I would have to su to root, then as each one of them to grant all the permissions I need. The only logical way I see to proceed is to always login as informix for creation/deletion of tables. We do that now, but have some old puppies that haunt us. The next game will be playing with systabauth (thanks, Alan), and changing all the owners of the tables to informix. Then, i'll be able to proceed as we wish. Naomi -- Naomi Walker (aka N7FSA) naomi@anasazi.com Phoenix, Arizona The best things in life aren't things.