Kbase 20692: Progress SQL-92: Grant privileges Without Creating Users?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/10/2008 |
|
Status: Verified
GOAL:
How to perform select queries against Database without adding users?
GOAL:
How to query a database using SQL-92 without adding users to the database?
GOAL:
How to grant permissions to a user without adding them to the _user table
GOAL:
Can a DBA grant privileges without creating users?
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
FIX:
A DBA may grant privileges to users who do not exist in the _user table by granting users to the PUBLIC domain. Granting permissions to public domain gives the specified privileges on the table or view to any user with access to the system.
When using SQL-92, only users who have been given permission via the SQL GRANT statement can access the tables. For example:
GRANT SELECT ON PUB.STATE TO PUBLIC;
COMMIT;