Simply execute

GRANT YOURROLE TO YOURUSER

Thomas

> -----Original Message-----
> From: gsbrown@... [mailto:gsbrown@...]
> Sent: Tuesday, August 14, 2001 5:35 PM
> To: IBObjects@yahoogroups.com
> Subject: Re: [IBO] Grants for users added using the IB_UtilityBar
>
>
> I have a role set up with access to all tables. How do I add the new
> user to this role from within my application? I have done it using
> Interbase Workbench but I want my application to do it. Is there a
> SQL statement that I can use to accomplish this?
>
> Thanks,
>
> Gerald S Brown
>
> --- In IBObjects@y..., "Artur Anjos" <arsoft@n...> wrote:
> > Use SQL Roles.
> >
> > Artur
> > ----- Original Message -----
> > From: gsbrown@G...
> > To: IBObjects@y...
> > Sent: Tuesday, August 14, 2001 2:47 PM
> > Subject: [IBO] Grants for users added using the IB_UtilityBar
> >
> >
> > I am using the IB_UtilityBar to add users. It adds the user to
> the
> > database fine but when I log in as that user it says I do not have
> > permissions on any of the tables. Is there some way to grant
> those
> > permissions to the new user from within IB? Do I have to create a
> SQL
> > statement to grant those privilages? If so how do I get the
> user's
> > name from the frmUsers.edAccount.text?
> >
> > Any suggestions will be greatly appreciated.
> >
> > Thanks,
> >
> > Gerald S. Brown
> >
> >
> > Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service.
> >
> >
> >
> > [Non-text portions of this message have been removed]
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>