Teradata Teradata Administration 2

Question 1

Which Teradata privilege allows a user to pass their granted privileges on to other users?

Accepted Answer

WITH GRANT OPTION

Answer

The WITH GRANT OPTION clause on a GRANT statement enables the receiving user to subsequently grant that same privilege to other users or roles.

Question 2

What is a Teradata role used for in security management?

Accepted Answer

Bundling a set of privileges that can be assigned to multiple users

Answer

A Teradata role is a named collection of privileges that simplifies security administration by allowing one role to be granted to many users instead of granting individual privileges repeatedly.

Question 3

Which DBC system view lists all privileges granted to users and roles in Teradata?

Accepted Answer

DBC.AccessRights

Answer

DBC.AccessRights displays all access rights (privileges) granted to users and roles, including the database object they apply to and whether WITH GRANT OPTION is set.

Question 4

What does the REVOKE statement do in Teradata?

Accepted Answer

Removes previously granted privileges from a user or role

Answer

REVOKE removes one or more previously granted privileges from a specified user or role, complementing the GRANT statement in Teradata's privilege management system.

Question 5

Which Teradata feature provides row-level security by filtering which rows a user can see in a table?

Accepted Answer

Row-Level Security (RLS) via security constraints

Answer

Teradata's Row-Level Security (RLS) uses security constraint columns and policies to automatically filter result sets so users only see rows they are authorized to access.

Teradata Practice Test

Teradata Practice Test

Teradata Teradata Administration 2