Multiple choice technology databases

Which of the following system catalog view contains the grantee information of the REFERENCE privilege on a view?

  1. SYSCAT.VIEWS

  2. SYSCAT.TABLES

  3. SYSCAT.TABAUTH

  4. SYSCAT.REFERENCES
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

SYSCAT.TABAUTH contains grantee information for table and view privileges including REFERENCE. SYSCAT.VIEWS has view metadata, SYSCAT.TABLES has table metadata, and SYSCAT.REFERENCES doesn't exist as a separate catalog view. TABAUTH is the authorization catalog tracking who has what privileges.

Keep practicing — related questions