Re: Grant privilege as DBA

On Mon, 24 Mar 1997 13:52:39 +0300, Maoz Mussel <mmussel@iil.intel.com> wrote: >Hi, > >I'm working with Informix online 5.1. I need to Grant DBA privilege >for another user, and I can't find the right command. I tried grant >ALL, but still some transactions that didn't worked for him. > >Please advice, thanks, >Maoz GRANT DBA to USER_NAME; This should work, Although I find it oddthat you would want to grant DBA to users. I think that this a bad idea. Why do users need DBA privilege? Why not assign table privilege to the users that need (update, delete, insert) Also, resource work as well.