Try something like an SQL statment with 'GRANT [Role] TO [YourUserName]'. Of course, the user that is using your app need to have the rigths to give grant to.

Artur

----- Original Message -----
From: gsbrown@...
To: IBObjects@yahoogroups.com
Sent: Tuesday, August 14, 2001 4:34 PM
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 the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]