community.borland.com

Article #25528: How to prevent users from creating tables

Problem:
I would like to restrict users from creating tables.
Is there any way I can do this via roles?

Solution:
The information in this article applies to:

You cannot restrict creation of tables via roles or SQL grant statements.

There are, however, two easy ways to restrict or workaround user creating unauthorized tables.

  1. Take the "D" flag out of the license file on the server. This will prevent any new metadata from being created. You will have to stop the server and restart it for this to take effect.
  2. Note: With InterBase v5 and later this is know as the metadata capability license.

  3. Periodically query rdb$relations and look for tables that you did not authorize the creation of. You can then drop the unauthorized tables.

Last Modified: 06-MAR-02