Jim Starkey wrote:

>>I think that people need to see advantages of the namespaces over just long
>>names. For example, an ability to specify a default namespace on a per
>>connection basis? Perhaps anything else? Please show us those benefits first
>>and then we'll get back to your implementation proposal.
>>
>>
>>
>>
>>
>
> OK:
>
> set schema fred;
> create table foo (yada yada yada) // creates table fred.foo
> select * from foo // selects from
> table fred.foo
> select * from fred.foo // also selects from
> table fred.foo
> select * from martha.foo // who's martha?
>

What about:
grant martha select on schema fred