How can you tell what privileges on a table or view have been granted to a user? (Choose two.)
How can you tell what privileges on a table or view have been granted to a user? (Choose two.)
The good answer is A,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 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
Why C is not correct? I tried and it worked
The answer B is not correct because the option "auth" does not exist with the command db2pd.
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