Managing database entities includes managing schemas and tables, and performing SQL management tasks.

To manage database entities, you need view database permissions on the database. Your organization administrator can create a role that has the necessary permissions, and the administrator can grant that role to you.

Permissions that you have on the organization apply to all database groups and databases in the organization. Permissions on a database group apply to all databases in the database group.

Data Director supports the following types of management tasks.

Database Entity Management

Database entity management includes creating, replacing, updating, and deleting database entities. These database entities include schemas, tables, views, indexes, functions, sequences, triggers, constraints, and users.

SQL Management

SQL management tasks include SQL profiling, query plan analysis, running ad-hoc queries or SQL scripts.