Creating schemas for virtual objects in Data Virtualization
You can use schemas to group virtual objects. A virtual object can belong to only one
schema. Use the CREATE SCHEMA SQL statement to create schemas.
About this task
If a schema does not exist in your Data Virtualization service, you must create a schema
explicitly. Any user can create a schema with their own authorization name by using a CREATE
SCHEMA statement. For example, user with user ID dv_ibmid_1001 can
create a private schema named dv_ibmid_1001. To enable other users or roles to use the schema, dv_ibmid_1001 must grant CREATEIN, ALTERIN, or
DROPIN schema permissions to these users or roles. Additionally, granting these permissions to
PUBLIC enables the schema to be shared by all users.
Data Virtualization Managers can create schemas based on names other than the existing user’s authorization name. Data Virtualization Managers must grant appropriate permissions to other users or roles for them to use the schema to create virtual objects.
As Data Virtualization Manager, you can grant IMPLICIT_SCHEMA permissions to a user with the Data Virtualization Engineer role for each project. Data Virtualization Engineer can then create schemas to be used by other users in their project. When schemas are created by using the IMPLICIT_SCHEMA permission, PUBLIC is granted the CREATIN permission on these schemas.