The question asks specifically what "privileges on a table or view have been granted to a user" then I believe answer C is not correct, as DBAUTH will tell if the user has some grant on the DB level, but not spefically on tables on view.
For me correct answers are A and E
My previous answer is wrong. I read too quickly the question.
The correct answer is
A. db2look with the -x option
E. Query the SYSCAT.TABAUTH view
The option -"x" with db2look : If this option is specified, the db2look utility will generate authorization DDL for existing granted privileges, excluding the original definer of the object
SYSCAT.DBAUTH is only to read the database-level privileges.
The good answer is C,E.
Each SYSCAT.DBAUTH's row represents a user, group, or role that has been granted one or more database-level authorities.
Each SYSCAT.TABAUTH's row represents a user, group, or role that has been granted one or more privileges on a table or view.
C. Query the SYSCAT.DBAUTH view
E. Query the SYSCAT.TABAUTH view CE
upvoted 1 times
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
maurosabi
3 years agojosomaa
3 years, 12 months agopieknyjoe
4 years, 5 months agodb2tester
5 years, 1 month agodb2tester
5 years, 1 month agodb2tester
5 years, 1 month ago