Privileges granted to users are specified in the following database system tables:

  • SYSPROGRESS.SYSCOLAUTH — This system table identifies users and the columns for which they have privileges. It also identifies the privileges the user has been granted, and the person who granted those privileges.
  • SYSPROGRESS.SYSDBAUTH — This system table identifies users who have authority to connect to a database, create tables, and perform administrative tasks.
  • SYSPROGRESS.SYSTABAUTH — This system table identifies users and the tables for which they have privileges. It also identifies the privileges the user has been granted, and the person who granted those privileges.