Hi,

From Sonali's mail
"When do you do default and NULL on the same column ?? "

I implement security like the following:

Assume that there is a table with 15 columns.
There are different types of users and according to their privileges the users will see different no. of columns.

So, I have created 3 views and created synonym's on these views through which the user's will insert the records.
1st view: 5 columns(one column has a default value and not null constraint for which this user does not
have an access)
2nd view: 10 columns
3rd view: 13 columns

In this case what I do is, give the default value as NA, so that this value will be updated by 2nd views owner or third view's owner.

Hope I have not confused you.

Vijay.