Gerald,

probably your user GBROWN hasn't any rights to modify the table USERS in the
Interbase Security database isc4.gdb.

Connect with SYSDBA to the isc4.gdb database and execute following
statement:

GRANT ALL ON USERS TO GBROWN;

Retry your changes with GBROWN in your application.

Hope this helps!
Thoms

> -----Original Message-----
> From: gsbrown@... [mailto:gsbrown@...]
> Sent: Wednesday, July 18, 2001 7:00 PM
> To: IBObjects@yahoogroups.com
> Subject: Re: [IBO] Adding users to DB
>
>
> I looked at IB_SQL and saw that it is using your IB_UtilityBar
> component so I used that in my application. The problem that I am
> now having in both my app and your IB_SQL is that if I log in as
> myself (gbrown) I keep getting error code # 335544754 when I try to
> add/change/delete a user. If I log in as SYSDBA it works OK. It
> looks like I need to change my settings (gbrown) on the database to
> match the SYSDBA settings. Do you have any ideas on how I can do
> that and is that feature available in IB_SQL?
>
> Thanks.
>
> Gerald S. Brown
>
> --- In IBObjects@y..., "Jason Wharton" <jwharton@i...> wrote:
> > It can all be done in code. Examine the sources of IB_WISQL (or
> IB_SQL in
> > ibo4) to get where you need to be.
> >
> > Jason Wharton
> > CPS - Mesa AZ
> > http://www.ibobjects.com
> >
> >
> > ----- Original Message -----
> > From: <gsbrown@G...>
> > To: <IBObjects@y...>
> > Sent: Tuesday, July 17, 2001 10:24 AM
> > Subject: [IBO] Adding users to DB
> >
> >
> > > Jason,
> > >
> > > On your TIB_Connection component there is an icon to add users to
> the
> > > database. Is there information anywhere on how to add users
> through
> > > code? Would it require a SQL statement? Also to grant rights to
> the
> > > user as they are added?
> > >
> > > Thanks,
> > >
> > > Gerald S. Brown
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>