Try OpenEdge Now
skip to main content
SQL Development
Data Control Language and Security : Granting privileges : GRANT statement : Granting public access
 
Granting public access
Example: Granting update privilege to public
The GRANT statement can be easily modified to make previously restricted columns accessible to the public, as in the following example.
GRANT UPDATE
ON Item (ItemNum, ItemName, CatDescription)
TO PUBLIC;
For detailed information on the GRANT statement, see OpenEdge Data Management: SQL Reference.