Kbase P93181: What is the meaning of the columns in SYSDBAUTH table?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
07/10/2008 |
|
Status: Verified
GOAL:
What is the meaning of the columns in SYSDBAUTH table?
GOAL:
What is the signification of SYSDBAUTH columns?
GOAL:
How to display the SYSDBAUTH table from a SQL-92 session?
GOAL:
How to query the SYSDBAUTH table from a SQL-92 session?
FACT(s) (Environment):
Progress 9.1x
OpenEdge 10.x
FIX:
grantee ? user name
dba_acc ? ?Y? means user has DBA privileges
blank ? means user does not have DBA privileges
res_acc ? ?Y? means user has RESOURCE privileges
blank ? means user does not have RESOURCE privileges
From a SQL session the following query may be run to display the contents of the SYSDBAUTH table:
select * from sysprogress.sysdbauth
The results will look similar to the following:
GRANTEE DBA_ACC RES_ACC
-------------------------------- ------- -------
administrator y y
SYSPROGRESS y y
P50496: "Sample 4GL code to list users who have SQL DBA access and resource privileges to a database."