You must have permissions to operate database tables. Also, the conditions must be met. This subsection describes permissions and conditions required for operating tables of each database. Here, a user connected to a database is called a user connected to database.

In HiRDB

Here, it is assumed that the user connected to a database performs all operations related to tables used in the database session failover functionality. The user connected to database must have the following permissions and satisfy the following conditions:

• User must own the schema.
• User must have CONNECT permissions.
• In the schema of the user connected to a database, create tables, indexes, and stored procedures used in the database session failover functionality.

For details on creating database tables, see 6.8.2 Creating database tables. For details on deleting database tables, see 6.11 Deleting database tables.

In Oracle

Here, it is assumed that the database administrator creates or deletes database tables used in the database session failover functionality, and that the user connected to a database of the database session failover functionality performs other usual database operations. The user connected to a database must have the following permissions and satisfy the following conditions:

• User must have CREATE SESSION system permissions.
• In the schema of the user connected to a database, create tables, indexes, and stored procedures used in the database session failover functionality.

For details on creating database tables, see 6.8.2 Creating database tables. For details on deleting database tables, see 6.11 Deleting database tables.