Data Vault Administrator Guide

6.4.4
- 6.5.1
- 6.5 HotFix 1
- 6.5
- 6.4.3 HotFix 1
- 6.4.3

Back Next

OWNER Privileges

This allows the recipient to create, alter, manipulate, drop, and grant/revoke privileges on objects in a schema that the user does not own. The OWNER privilege does not
confer the ability to GRANT schema privileges or to drop the schema. This privilege is only valid with schemas; attempting to grant the OWNER privilege on a table or domain will produce an error message.

SELECT: This allows the user to retrieve data from the specified table, or all tables in the specified schema. The privilege can be granted on specific columns in the specified table by listing their names (within parentheses, and separated by commas) after the SELECT keyword. If a column list is not included, the privilege applies to all columns in the table.
INSERT: This allows the user to insert data into the specified table, or all tables in the specified schema. The privilege can be granted on specific columns in the specified table by listing their names (within parentheses, and separated by commas) after the INSERT keyword. If a column list is not included, the privilege applies to all columns in the table.
UPDATE: This allows the user to update data in the specified table, or all tables in the specified schema. The privilege can be granted on specific columns in the specified table by listing their names (within parentheses, and separated by commas) after the UPDATE keyword. If a column list is not included, the privilege applies to all columns in the table.
DELETE: This allows the user to delete data from the specified table, or all tables in the specified schema.
USAGE: This allows the user to specify domain name
as the domain argument in a column definition.
ALL PRIVILEGES: The following table lists the individual privileges granted on a database object with ALL PRIVILEGES:

Table
Schema
Domain

SELECT
Yes
Yes
No

INSERT
Yes
Yes
No

UPDATE
Yes
Yes
No

DELETE
Yes
Yes
No

USAGE
No
Yes
No

When a privilege is granted on a schema, that privilege applies to all objects belonging to the schema. For instance, granting SELECT on a schema allows the grantee to SELECT from any table in the schema.