Security Rule [message #316560] |
Fri, 25 April 2008 13:30 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
mpflukin
Messages: 2 Registered: April 2008 Location: Atlanta
|
Junior Member |
|
|
If my value set is alpha-numeric and "right justify zero filled" is off can I set up a security rule attached to a responsibility that requires entry of a valid value by using the range 1 - ZZZZ? And if I did not require any value be entered I would make the range 0 - ZZZZ?
|
|
|
Re: Security Rule [message #318430 is a reply to message #316560] |
Tue, 06 May 2008 17:57 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
mpflukin
Messages: 2 Registered: April 2008 Location: Atlanta
|
Junior Member |
|
|
OK another question. If my value set is alphanumeric zero-fill right justify should I use 0001-ZZZZ or 1-ZZZZ? Is 0001 "greater than" 1?
|
|
|
Re: Security Rule [message #318553 is a reply to message #318430] |
Wed, 07 May 2008 03:05 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
Puskado
Messages: 38 Registered: May 2007
|
Member |
|
|
Hi
Each an evry segment have size or number of characters in a segment. You must use 0001 - ZZZZ and be aware that you need to include 0000 - ZZZZ then exclude ranges that you don't need.
|
|
|