# Unable to set pseudo column USER as default value for a column

**URL:** <https://forum.liquibase.org/t/unable-to-set-pseudo-column-user-as-default-value-for-a-column/2068>\
**Category:** General Discussion\
**Created:** [August 21, 2012, 7:53pm UTC](https://forum.liquibase.org/t/unable-to-set-pseudo-column-user-as-default-value-for-a-column/2068 "2012-08-21T19:53:00Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![hakkika](https://avatars.discourse-cdn.com/v4/letter/h/ecc23a/32.png) [@hakkika](https://forum.liquibase.org/u/hakkika)\
**Post date:** [August 21, 2012, 7:53pm UTC](https://forum.liquibase.org/t/unable-to-set-pseudo-column-user-as-default-value-for-a-column/2068/1 "2012-08-21T19:53:00Z")

</div>

Hi,  
  
I’m using Oracle database and Liquibase 2.0.5.  
  
It seems there is no way to set pseudo column USER as default value for a VARCHAR2 type column.  
The default value always ends up as string ‘USER’.  
  
I have tried defaultValueDate as some of the previous posts suggests, but that produces  
java.lang.ClassCastException.  
  
I managed to get it working by using the following modifySql element:  
  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;   
  
  
But is that really the only possible way?  
  
Regards,  
Kari

---

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forum.liquibase.org/u/Guest)\
**Post date:** [August 21, 2012, 7:53pm UTC](https://forum.liquibase.org/t/unable-to-set-pseudo-column-user-as-default-value-for-a-column/2068/2 "2012-08-21T19:53:00Z")

</div>

Did you find a solution to this? &nbsp;Still doesn’t work ing 3.0.7.

---

<div class="post-metadata">

**Author:** ![nvoxland](https://avatars.discourse-cdn.com/v4/letter/n/87869e/32.png) [@nvoxland](https://forum.liquibase.org/u/nvoxland)\
**Post date:** [August 21, 2012, 7:53pm UTC](https://forum.liquibase.org/t/unable-to-set-pseudo-column-user-as-default-value-for-a-column/2068/3 "2012-08-21T19:53:00Z")

</div>

Does it work if you use defaultValueComputed=“USER” ?  
  
Nathan