Try OpenEdge Now
skip to main content
SQL Development
Data Control Language and Security : Verifying privileges
 

Verifying privileges

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.