Kbase P25358: What does the "g" value in the sysprogress.systabauth table mean?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
8/12/2009 |
|
Status: Verified
GOAL:
What does the "g" value in the sysprogress.systabauth table mean?
GOAL:
What does the "G" stand for when looking at items in sysprogress.systabauth?
FACT(s) (Environment):
UNIX
Windows
Progress 9.1x
FIX:
When the following SQL command
select * from sysprogress.systabauth
is issued to list the contents of the database authorization table you can obtain "g" as a value under the following columns:
INS DEL UPD SEL EXE NDX ALT REF
In the sysprogress.systabauth table, "g" means that the privilege was granted with the SQL GRANT statement. This means that the user with this privilege can, in turn, grant it to someone else.