Subject | Security of databases in Firebird 1.0.3 |
---|---|
Author | lists |
Post date | 2003-09-02T18:14:50Z |
Hello everybody,
I'm just instaled Firebird 1.0.3 and want to use it on my webhosting server.
My request is: Any user can connect to her database, but don't have any
privileges in any other database.
Unfortunately:
# /opt/interbase/bin/gsec
$ /opt/interbase/bin/isql -u user -pw pass
...
RDB$CHARACTER_SETS
RDB$COLLATIONS
RDB$EXCEPTIONS
RDB$ROLES
HOST_INFO
USERS
And more:
I'm sure, I didn't give any privileges to firebird user "user".
Is there anybody, who knows the sollution?
I'm running Firebird form ined superserver as user "firebird"
Many thanks
Regards
Antonin Karasek
I'm just instaled Firebird 1.0.3 and want to use it on my webhosting server.
My request is: Any user can connect to her database, but don't have any
privileges in any other database.
Unfortunately:
# /opt/interbase/bin/gsec
> a user -pw pass# exit
> q
$ /opt/interbase/bin/isql -u user -pw pass
> connect localhost:/opt/interbase/isc4.gdb ;...
> select rdb$relation_name from rdb$relations ;
...
RDB$CHARACTER_SETS
RDB$COLLATIONS
RDB$EXCEPTIONS
RDB$ROLES
HOST_INFO
USERS
And more:
> select * from users ;- lists users and encrypted passwords :((
I'm sure, I didn't give any privileges to firebird user "user".
Is there anybody, who knows the sollution?
I'm running Firebird form ined superserver as user "firebird"
Many thanks
Regards
Antonin Karasek