Subject [resolution] Some method to retrieve all users in security2.fdb ?
Author hamacker
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]