Kbase P134225: How to check permissions on a table in SQL92?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
18/07/2009 |
|
Status: Unverified
GOAL:
How to check permissions on a table in SQL92?
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
FIX:
The following select statement will display the privileges assigned to a table:
select * from sysprogress.systabauth where TBL=<insert table name here>;
Example with sports2000 database for the benefits table:
select * from sysprogress.systabauth where TBL='benefits';
GRANTOR GRANTEE TBLOWNER
TBL INS DEL UPD SEL EXE NDX ALT REF
-------------------------------- -------------------------------- --------------
------------------ -------------------------------- --- --- --- --- --- --- ---
---
PSCBLD PSCBLD PUB
BENEFITS g g g g g g g