Default Security and Access

From InterBase
Jump to: navigation, search

Go Up to Overview of SQL Access Privileges


All tables and stored procedures are secured against unauthorized access when they are created. Initially, only a creator of a table, its owner, has access to a table, and only its owner can use GRANT to assign privileges to other users or to procedures. Only a creator of a procedure, its owner, can execute or call the procedure, and only its owner can assign EXECUTE privilege to other users or to other procedures.

InterBase also supports a SYSDBA user who has access to all database objects; furthermore, on platforms that support the concept of a superuser, or user with root or locksmith privileges, such a user also has access to all database objects.

Advance To: