I enjoyed the learning experience and was able to understand the instructor
However, I had an issue with one of the questions in the quiz. If the following is documented in the course:
The table owner and the database owner automatically gain the following privileges on the table and are able to grant these privileges to other users: INSERT, SELECT, REFERENCES, TRIGGER and UPDATE. These privileges cannot be revoked from the table and database owners.
Quiz Question:
Can the insert, select, references, trigger and update privileges be revoked from the table and database owners?
The answer should be ==> No , but I was marked incorrect indicating I should have selected "yes".
I don't understand this answer if it is clearly stating that the above privileges CANNOT BE REVOKED from the table and D/B owners.
The result from the quiz says... it should be yes ==>- Sorry, no. The table and database owner automatically gain thee privileges and can grant them to other users.
The above statement does not answer the question asked. The question was can the privileges be revoked from the owners.