Get Unlimited Contributor Access to the all ExamTopics Exams!
Take advantage of PDF Files for 1000+ Exams along with community discussions and pass IT Certification Exams Easily.
answer A
SQL0556N An attempt to revoke a privilege, security label, exemption, or role from authorization-ID was denied because authorization-ID does not hold this privilege, security label, exemption, or role.
Explanation
The privilege, security label, exemption, or role cannot be revoked because authorization-ID does not hold the privilege, security label, exemption, or role.
The statement cannot be processed.
User response
Change the REVOKE statement to conform to the REVOKE rules and resubmit the statement. Ensure that when a REVOKE statement lists several privileges, security labels, exemptions, or roles to be revoked and a list of authorization IDs that each authorization ID possesses at least one of the specified privileges, security labels, exemptions, or roles.
sqlcode: -556
sqlstate: 42504
sqlcode: -556 --> negative code means error for DB2
The good answer is "A. An error is returned "
You will get the following error : SQL0556N An attempt to revoke a privilege, security label, exemption, or oral from "MYUSER" was denied because "MYUSER" dos not hold this privilege, security label, exemption, or role.
upvoted 3 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
2 years, 4 months agopieknyjoe
3 years, 10 months agodb2tester
4 years, 6 months ago