View authorities for Sam



You must log into the database as Pat before proceeding with this page.

From the previous page we saw that Sam is explicitly granted with DBADM authority without DATAACCESS and ACCESSCTRL authorities. Check what authorities Sam has received implicitly/explicitly after he was granted with DBADM authority.


Operation



Use AUTH_LIST_AUTHORITIES_FOR_AUTHID table function to check what authorities Sam got after he was granted with DBADM authority.


Solution



Example of the right shows that Sam has DBADM and other authorities granted implicitly with DBADM. However, he doesn't have DATAACCESS and ACCESSCTRL authorities.