Subject | Re: [IBDI] Internet |
---|---|
Author | Peter Morris |
Post date | 2001-06-05T08:35:01Z |
> AFAIK only the SYSDBA and the table owner can extract theThis may have been the intention, but it is not the case.
> metadata.
I just did this
1) Log in as sysdba
2) Create a database + table
3) Create a user "pete_m" with no permissions to any databases
4) Log in as pete_m
5) Extracted the meta data for the new database without problems
6) Added a new table to the database without problems
The difference between IB and MS SQL is twofold
1) MS SQL will not allow the above but shows a list of all databases
2) IB will allow the above, but you have to find the database first
The problem is that finding a database isn't always that difficult
(especially if the ISP insists on a convention of some kind, eg all
databases must go in your /db directory or we wont set up an ODBC entry).
You can probably (not sure though) get the path of a DB from the ODBC
connection anyway.
I think both DBs are incorrect, MS SQL should not show the other databases
unless you register them, but IB has the worst case where meta-data
(copyrighted information) is extractable without any access permission, and
the database may have new tables added !
I am sure anyone in the slightest bit concerned (paranoid ?) about their
database security will agree with me that relying on the hacker not to
"guess" where a database is is a bad idea. Unix permissions do not come
into this as it may be a windows machine.
Pete