security.syspermissions is a security model table that tracks explicit GRANT and DENY permissions against Cirro users.
Column Name Type Length Nullable Contents
grantee VARCHAR 512 true Recipient of the permission.
grantor VARCHAR 512 true Grantor of the permission.
permissiontype VARCHAR 512 true Name of the permission. See PRIVILEGE MAPPINGS
grantable INTEGER 10 true Object ID for the object on which permissions are granted or explicitly denied.
deny INTEGER 10 true A “1” if this is a DENY rather than a grant.
lastupdate DATE 10 true Date last updated.
ondatabase VARCHAR 512 true Database on the remote system where this permission applies.
onschema VARCHAR 512 true Schema on the remote system where this permission applies.
onsystemid VARCHAR 512 true Remote system where this permission applies.
deleted        
key_name