Data Vault Administrator Guide

6.5.1
- 6.5 HotFix 1
- 6.5
- 6.4.4
- 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.