View system tables relevant to USER Accounts

View all users

User accounts are added to the SYS.Users table.

SELECT * FROM SYS.USERS

View All Permissions

Users granted Cirro permissions are listed as grantee in SYS.PERMISSIONS.

SELECT * FROM SYS.SYSPERMISSIONS

View All Roles

Users granted Cirro Roles are listed as grantee in SYS.SYSROLES.

SELECT * FROM SYS.SYSROLES

View currently logged-in users

The USER_SESSIONS table lists all current connections.

SELECT * FROM SYS.USER_SESSIONS