Re: grant dba/unload

kickers07@aol.com (Kickers07) wrote: :hello there, :i've typed the grant dba to username1. Why do you want to do this. Normaly you grant only connect or possibly (not often I hope) resource to other users than the actual dba. :scipts with unload to /users1/dos....does'nt work. they only work with the :root password. why? :thanks,tom Well, if you gave us something to go by as to what version of what database (Informix I asume) you are using on what platform it might be easier. Also posting the actual commands (scripts) and what program you use to run them would make it all much easier. I might guess: 1. Your unload statement is wrong. There is a syntax error. 2. The user doing this have no access rights (despite your grant statement). 3. You have no right to write to the file you are trying to unload to. But why should I guess - why should I spend time on something you might have told us in the first place. Sorry for a little gripe. Please dont be offended. Pleas simply post a followup with a little more info and someone will help you. Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company The Informix FAQ is at http://www.iiug.org