annoynimouse
annoynimouse
i assume u use Unix. Generally in FB 3 (i think would not be released for year or two) many things gonna change, but as of now FB server process...
Generally you'd to read firbebird.conf text file and analyze the options descryptions. They sometimes are better described in documentation upgrade text fiels or release notes but i don't know of...
http://www.firebirdsql.org/manual/fbmetasecur.html http://www.firebirdsql.org/manual/qsg25-config.html You'd filter out user attempts at CREATE/ALTER/DROP DATABASE/SCHEME/SHADOW http://firebirdsql.su/doku.php?id=create_database http://firebirdsql.su/doku.php?id=alter_database http://firebirdsql.su/doku.php?id=drop_database http://firebirdsql.su/doku.php?id=create_shadow http://firebirdsql.su/doku.php?id=drop_shadow
Database should be created with "SQL Dialect 3", dialect 1 is legacy of no practical use. Dialect 2 is of no use except testing at all. You'd probably allow user...
SYSDBA is specific user, that has every access to databases. You should not connect as SYSDBA except for administrative tasks like deleting obsoleted databases. any user can create any new...