Are you sure this will work?

In Oracle you can have unrelated tables of the same name in different
schemas. My impression was that in Firebird this was not possible.
Without this capability I think using schema to identify the user will
result in more confusion than benefit.

Other opinions?

thanks
david jencks

On 2002.04.25 21:03:26 -0400 Blas Rodriguez Somoza wrote:
> Hello
>
> Since all databases that I know uses JDBC schemas as a synonym of
> users
> I suppose that Firebird can do the same . I propose to use the owners of
> Tables and Procedures as the schema names (columns RDB$OWNER_NAME) as
> other
> databases do.
>
> I send in the mail an implementation of the getSchemas method.
>
> If the schemaPattern is used then some methods will need to be
> modified
> to take schemaPattern into account. I had make the changes
> and will send it if the proposal is accepted.
>
> Regards
> Blas Rodriguez Somoza.
>
>
> To unsubscribe from this group, send an email to:
> Firebird-Java-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>