Re: Grant Option

->From: naomi@anasazi.com (Naomi Walker) ->Subject: Re: Grant Option ->To: jparker@hpbs2561.boi.hp.com (Jack Parker) ->Date: Fri, 25 Feb 94 8:43:45 MST ->Cc: informix-list@rmy.emory.edu (Informix List) ->> > ->> > 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 Hi, again, Naomi, IF your version of ISQL will let you update the sys... tables, then you will want to change systables and sysindexes, which is where the owner names are stored. (The systabauth trick that I sent to you [off-net] is a way of granting "select with grant option" without changing the table ownerships.) I don't know but I've been told that logging in as user informix is a not-so-hot idea. Maybe you want a special "superdba" login instead, for doing your table maintenance. Regards, Alan ___________________________ ______________________| R. Alan Popiel |__________________________ \\ Internet: | Martin Marietta, SLS | / \\ alan@den.mmc.com | P.O. Box 179, M/S 3810 | Std disclaimers apply. / )Voice: | Denver, CO 80201-0179 USA | ( / 303-977-9998 |___________________________| (But you knew that!) \\ /________________________) (____________________________\\