Try OpenEdge Now
skip to main content
Programming Interfaces
Data Management : Database Access : Sequences : Creating and maintaining sequences : Providing sequence security
 
Providing sequence security
You can restrict sequence access by assigning user privileges to the _Sequence metaschema table. The Can–Read privilege grants users permission to read the current value of a sequence with the CURRENT–VALUE function or to increment and read the next value of the sequence with the NEXT–VALUE function. The Can–Write privilege grants users permission to change the current value of a sequence with the CURRENT–VALUE statement.
Note: Access privileges to the _Sequence metaschema table are in effect during compile-time and during run-time.
For more information on providing security to a database table, see OpenEdge Data Management: Database Administration.