Raymond,

> > > FB1.5.
> > >
> > > In a database I created recently, there are 2 other users according

to

> > > IBExpert:
> > > Survey_User1
> > > Survey_User2
> > >
> >
> > there are no users in a database.. do you mean role? or do you mean they

now

> > appear in your security database?
>
> In IBExpert, I opened the database I created and ran the menu command
> Tools/User Manager. These 2 users appears.

You might want to check something too in the IBExpert Grant Manager.

Do this:

grant all to fake_user on <tablename>

Then, start the Grant Manager and see if "fake_user" appears.

With Firebird, you can easily grant rights to non-existent users. Users
are created on a server basis.

It might be, that IBExpert reads the system privileges table and adds
to user to the "list of available users".


With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com