SetObjectSecurityProfile - Teradata Meta Data Services

Teradata Meta Data Services Programmer Guide

Product
Teradata Meta Data Services
Release Number
15.00
Language
English (United States)
Last Update
2018-09-28
Product Category
Teradata Tools and Utilities

SetObjectSecurityProfile

Purpose

The SetObjectSecurityProfile function assigns the Security Profile ID (set in the object) to the objects specified in the objList.

Requirements

All objects in the list must be in the same class.

You must be initialized as a super user to use this function.

Description

If PropagateFlag is set to MD_PROPAGATE, the Security Profile ID in all related objects will also be updated.

Related objects are determined by the containment relationships of the specified object. A containment relationship is a relationship that has delete propagation flag turned on. If object A is said to contain object B, it means that A is the origin object and B is the destination object of a containment relationship. Propagation will continue until an object is reached which has no containment relationships.

It is assumed that many customers will partition access to DIM objects based on databases. Most of the DIM relationships are containment relationships. The “propagate” feature allows administrators to set the security profile ID on a specific database object and the security profile ID will be propagated to all objects in the database.

Syntax

HRESULT SetObjectSecurityProfile (
	MetaObjectIDVector &objList,
	const short PropagateFlag);
 

Argument

In/Out

Description

objList

In

List of object IDs.

PropagateFlag

In

Set to one of the following:

  • MD_NULL – do not update related objects.
  • MD_PROPAGATE - update the security profile ID in all related objects.
  • Figure 26: Propagate Permissions from Database