View SYSADM authorities



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

Check what authorities the database creator holds after creating the 'security' database.

Operation



Run the Ad hoc SQL on the right.

Using the table function SYSPROC.AUTH_LIST_AUTHORITIES_FOR_AUTHID, you can check what authorities the database creator holds now.

Table function SYSPROC.AUTH_LIST_AUTHORITIES_FOR_AUTHID returns all authorities held by the current user (ie database creator). The function accepts two input arguments


Solution



The query results in the right pane show that, the database creator holds SYSADM, DBADM, SECADM, ACCESSCTRL, DATAACCESS authorities along with CREATETAB, BINDADD, CONNECT, and IMPLICIT_SCHEMA authorities.

The same information can be obtained from the Information > My Authorities menu in TE.