Thanks. That worked.

--- In IBObjects@y..., "Thomas Steinmaurer" <thomas.steinmaurer@a...>
wrote:

> 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@G... [mailto:gsbrown@G...]
> > Sent: Wednesday, July 18, 2001 7:00 PM
> > To: IBObjects@y...
> > 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/

> >
> >
> >
> >