Subject Re: [resolution] Some method to retrieve all users in security2.fdb ?
Author benjamini_bbf
Hi,

Try this:

UserName := 'isc_spb_user_name=YOUR_USER_NAME'
Password := 'isc_spb_password=your_password'

Edison

PS: é bom ver gente conhecida na lista :D


--- In IBObjects@yahoogroups.com, hamacker <sirhamacker@...> wrote:
>
> I found a solution, IBOAdmin does not requer UserName and Password
as
> property, but as TParams.
> if I fill Username and Password then 'SPB constant not supported'
error
> appear, if fill as blank but add params like 'user_name'
and 'password' then
> everything is OK.
>
> Thanks a lot .
>
>
> 2007/12/3, hamacker <sirhamacker@...>:
> >
> > Hi Again,
> >
> > I found and I did install IBOAdmin, but studing your properties
I conclude
> > that to retrieve all users :
> > var ResultList:TStringLIST;
> > n:Integer;
> > begin
> > ResultList:=TStringLIST.Create;
> > with IBOSecurityService1 do
> > begin
> > UserName:=FormMAIN.FB_SERVER.Username;
> > Password:=FormMAIN.FB_SERVER.Password ;
> > LoginPrompt := False;
> > ServerName:=FormMAIN.FB_SERVER.Params.Values['SERVER'];
> > Params.Clear;
> > Params.AddStrings(FormMAIN.FB_SERVER.Params);
> > Protocol:=FormMAIN.FB_SERVER.Protocol;
> > try
> > Attach;
> > for n:=0 to (IBOSecurityService1.UserInfoCount) do
> > begin
> > // UserName := Edit1.Text;
> > // DisplayUser(UserName);
> > // Edit2.Text := UserInfo[0].FirstName;
> > // Edit3.Text := UserInfo[0].MiddleName;
> > // Edit4.Text := UserInfo[0].LastName;
> > // Edit5.Text := IntToStr(UserInfo[0].UserID);
> > // Edit6.Text := IntToStr(UserInfo[0].GroupID);
> > ResultLIST.Add (UserInfo[0].FirstName);
> > end;
> > except
> > on e:exception do
> > begin
> > Application.MessageBox(Pchar(e.message),Pchar('Can not
attach
> > '+ServerName+':'));
> > end;
> > end;
> > Active:=false;
> > end;
> >
> > But ever "SPB constant not supported" appear.
> > How can I retrieve all logins using IBOAdmin, some idea ?
> >
> >
> > 2007/12/2, Alan McDonald <alan@...>:
> > >
> > > Google is your friend
> > > IBOAdmin - the first in the list
> > > Alan
> > >
> > > > -----Original Message-----
> > > > From: IBObjects@yahoogroups.com <IBObjects%40yahoogroups.com>
> > > > [mailto:IBObjects@yahoogroups.com <IBObjects%
40yahoogroups.com>] On
> > > Behalf Of hamacker
> > > > Sent: Monday, 3 December 2007 8:07 AM
> > > > To: IBObjects@yahoogroups.com <IBObjects%40yahoogroups.com>
> > > > Subject: Re: [IBO] Some method to retrieve all users in
> > > > security2.fdb ?
> > > >
> > > >
> > > > I do not have this component on my pallete.
> > > > Where is it ?
> > > >
> > > > 2007/11/30, Alan McDonald < alan@... <alan%40meta.com.au>>:
> > > > >
> > > > > > I need a help,
> > > > > >
> > > > > > In FB1.x I connect directly to security.fdb to retrieve
> > > > all logins,
> > > > > > but in FB2 it does not possible, only via API.
> > > > > >
> > > > > > I am a newbie in IBO Components, I tried to
> > > > IB_Connection.Users by
> > > > > > this method retrieve only connected users and I need to
> > > > all logins
> > > > > > (connected or not).
> > > > > >
> > > > > > Ideas ?
> > > > >
> > > > > You'll have to use the IBOAdmin components for start.
> > > > > And you'll have to hack the security2.fdb file to grant
> > > > public to the
> > > > > users view.
> > > > >
> > > > > Alan
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > > > [Non-text portions of this message have been removed]
> > > >
> > > >
> > > >
> > > > __________________________________________________________
> > > > _____________
> > > > IB Objects - direct, complete, custom connectivity to
> > > > Firebird or InterBase
> > > > without the need for BDE, ODBC or any other
> > > > layer.
> > > > __________________________________________________________
> > > > _____________
> > > > http://www.ibobjects.com - your IBO community resource for
> > > > Tech Info papers,
> > > > keyword-searchable FAQ, community code contributions and more
> > > > !
> > > > Yahoo! Groups Links
> > > >
> > > >
> > > >
> > > >
> > >
> > >
> > >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>