A00-250 practice question 10 of 15

For metadata library connections to an RDBMS, which statement is true?

Full set: 65 questions
Answer options
A: Security is only applied if the library is pre-assigned.
B: Security can be applied only in the RDBMS.
C: Security can be applied only in SAS metadata.
D: Security can be applied in SAS metadata and in the RDBMS. Correct answer
Correct Answer:
D. Security can be applied in SAS metadata and in the RDBMS.
Explanation

When accessing a Relational Database Management System (RDBMS) through a SAS metadata-defined library, a dual-layered security model is applied. First, the SAS Metadata Server evaluates the user's permissions on the metadata objects (e.g., the library and table definitions). A user must have at least ReadMetadata permission to see the library. If this check passes, the connection is attempted. Second, the RDBMS enforces its own native security model. The credentials used for the database connection must have the appropriate privileges (e.g., SELECT, INSERT) on the underlying database objects. Access is granted only when permissions are sufficient in both security layers.

Why Incorrect

A. Security is applied to the metadata object itself, regardless of whether the library is pre-assigned or assigned dynamically upon request.
B. This is false because it ignores the mandatory SAS metadata security layer that controls access to the library definition itself.
C. This is false because the RDBMS always enforces its own native security on the physical data, independent of SAS metadata permissions.

References

1. SAS® 9.4 Intelligence Platform: Security Administration Guide, Second Edition.

Reference: Chapter 11, "Securing Data," Section: "How Authorization Decisions Are Made for Data," p. 163.

Quote/Concept: The documentation explains the flow of authorization. It states, "For external data such as a table in an Oracle database, the database server makes the final decision about whether to grant access." This confirms that the RDBMS security is the final authority on the data, while preceding paragraphs describe how the SAS Metadata Server first checks permissions on the metadata objects.

2. SAS/ACCESS® 9.4 for Relational Databases: Reference, Eighth Edition.

Reference: Part 1, "SAS/ACCESS Concepts," Chapter 2, "SAS/ACCESS LIBNAME Statement," Section: "LIBNAME Statement Syntax for Relational Databases," p. 20.

Quote/Concept: The documentation details connection options like USER= and PASSWORD=, stating these are the "database user name" and "database password." This explicitly shows that authentication and subsequent authorization are handled by the target RDBMS using its own security credentials, which is separate from the SAS metadata security layer.

Scroll to Top