Re: Help moving from Application to Database Security

"Steve S" <stevens_at_coloradocustomware.com> wrote in message news:bafba412.0105311320.45c01dd2_at_posting.google.com...
> Thanks for your help.
> Do you know if there is a way to have a default schema, besides your
> own? If user 'John' signs on, can he reference schema tom without the
> tom. prefix on all the tables and other objects?

No
If that is a common schema (to every user) you need to setup public synonyms, else use private synonyms.
I wouldn't recommend hardcoding the owner in all your statements. (Let the flames begin)

Hth,
Sybrand Bakker, Oracle DBA Received on Fri Jun 01 2001 - 02:22:00 CDT