Valid NAS-C01 Dumps shared by EduDump.com for Helping Passing NAS-C01 Exam! EduDump.com now offer the newest NAS-C01 exam dumps, the EduDump.com NAS-C01 exam questions have been updated and answers have been corrected get the newest EduDump.com NAS-C01 dumps with Test Engine here:
A Native Application provider is developing an application that relies on data residing in a shared database, 'EXTERNAL DATA'. They want to ensure that their application role 'app_role' only has access to specific tables and views within 'EXTERNAL DATA', and they also want to minimize the need for future privilege grants as new tables are added to 'EXTERNAL DATA. Which combination of SQL statements below achieves these goals with the principle of least privilege in mind? Assume all tables are in the PUBLIC schema.
Correct Answer: C
The correct answer is C. First, IMPORTED PRIVILEGES is required so that the Native App can see the database. Next, GRANT SELECT ON FUTURE TABLES IN SCHEMA EXTERNAL DATA.PUBLIC limits the scope of future grants only to the PUBLIC schema. The other options do not provide future grants scoped to the Public schema, or they grant ALL access. Options B and D require that the database USAGE privilege be explicitly granted in addition to IMPORTED PRIVILEGES, which are granted automatically when a database is shared. Option E is incorrect because 'ALL TABLES does not cover tables that will be created in the future.