Kbase P127792: How can rights be defined for SQL92 when no users exist in the _user table?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/07/2008 |
|
Status: Verified
GOAL:
How can rights be defined for SQL92 when no users exist in the _user table?
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
OpenEdge Category: SQL
FIX:
Rights may be imprinted on a per table basis for all user tables within SQL92 in the Progress / OpenEdge database.
Entries are created within the database which define what rights the users are given for particular tables (this can be done even if no users have been created in the database).
If no entries exist in the _user table then the operating system user table is used to authenticate the identity of a user. Those users which submit a username and password which match the OS username and password are allowed into the database. When those users attempt to perform operations on tables within the database, the entries within the database which define rights to the table are checked to see if the userid supplied by the user is allowed to perform the operation requested.