Re: change users' default schema

On 11/3/06, Johnson, George <GJohnson_at_gam.com> wrote:
>
>
> What about proxy users? You can still fully audit the actions
> then.
>
> "alter user1 grant connect through user2"
> "conn user2[user1]@db99"
>
>

As far as I can see from the docs, that only works through a thick JDBC connection or OCI. It's for use by an app server.

If you have a way to make it work with sqlplus, I would love to see it.

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l