Kbase P8511: How to set permissions on database tables
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
9/12/2008 |
|
Status: Verified
GOAL:
How to set permissions on database tables
GOAL:
How to use database table security
GOAL:
How to set security on tables to exclude users
GOAL:
How to exclude users table permissions
FACT(s) (Environment):
All Supported Operating Systems
Progress/OpenEdge Versions
FIX:
These can be entered against the relevant permissions on each table through the Data Dictionary/Administration Tool:
[Data Administration] -> <Admin> -> <Security> -> <Edit Data Security>
# = All users
!<u1> = All except u1
ab* = All beginning with AB
Using the "!" character before the user name will exclude that user.
For example:
[Can_Delete] "!promise,!performance",!pc2*,*"
This will exclude users "promise", "performance" and all users beginning with "pc2".
Don't forget to include the "*" at the end for the remaining users.