Mask or hide the value 1

[dreampolice]

In OEM on my client workstation can I mask a view of a field value? For example I have a password that I store and I can see the value but would like to mask it so no one can see the password.

Please advise. In Access they have a mask option where in design mode you can mask a field value. Can I do the same in my OEM or anywhere in Oracle??

 

[SantaMufasa]

DreamPolice, To whom have you GRANTed access privileges to your table? If you don't want people to see values in your table, you can either

a) do not GRANT access on the table, or
b) create a VIEW on the table so that the VIEW contains only fields that you want the others to see, and GRANT access on the VIEW.

Let us know if there are details that I have missed.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]

 

[dreampolice]

Thank you that works with a view.