Clarified Deny Between clause for Alter role
@@ -195,12 +195,19 @@ ALTER ROLE <varname>name</varname> RESOURCE GROUP {<varname>group_name</varname>
formats:<p>For
day:</p><codeblock>{'Sunday' | 'Monday' | 'Tuesday' |'Wednesday' | 'Thursday' | 'Friday' |
'Saturday' | 0-6 }</codeblock><p>For
- <codeph>time:</codeph></p><p>{ 00-23 : 00-59 | 01-12 : 00-59 { AM | PM }}</p></pd>
+ <codeph>time:</codeph></p></pd>
+ <pd>
+ <codeblock>{ 00-23 : 00-59 | 01-12 : 00-59 { AM | PM }}</codeblock>
+ </pd>
<pd>The <codeph>DENY BETWEEN</codeph> clause uses two <varname>deny_point</varname>
- parameters.</pd>
+ parameters which must indicate day and time.</pd>
<pd>
<codeblock>DENY BETWEEN <varname>deny_point</varname> AND <varname>deny_point</varname></codeblock>
</pd>
+ <pd>For example:</pd>
+ <pd>
+ <codeblock>ALTER USER user1 DENY BETWEEN day 'Sunday' time '00:00' AND day 'Monday' time '00:00'; </codeblock>
+ </pd>
<pd>For more information about time-based constraints and examples, see "Managing Roles
and Privileges" in the <i>Greenplum Database Administrator Guide</i>.</pd>
</plentry>
