Data Vault Administrator Guide

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

Back Next

Examples of Owner Privileges

The following example grants all authorization IDs the ability to update two specific columns (“col1” and “col3”) in a table called “my_table”:

GRANT UPDATE (col1, col3) ON TABLE my_table TO PUBLIC;

In this case, users without DBA privileges, who possess no other privileges on my_table
, cannot update any other columns.

The following example grants DBA privileges to an authorization ID called “marketing”:

GRANT DBA TO marketing;

The following example grants to authorization IDs “clive”, “bertrand”, and “nigel” the ability to specify domain “d_char” as a domain argument in a column definition (and also to GRANT USAGE on the domain to other users):

GRANT USAGE ON DOMAIN d_char

     TO clive, bertrand, nigel WITH GRANT OPTION;

Rename Saved Search

Table of Contents

Data Vault Administrator Guide

Data Vault Administrator Guide

Examples of Owner Privileges

Examples of Owner Privileges