MySQL native connector and user accounts?

[drewjensen]

Hi,

The question is - 0,1, or 2 issues here?

The situation.

Create two schema in a MySQL database:
Alpha
Beta

With at least 1 table in each schema.

Create a user account in the database with full access rights to both
schema.

Create a Base file with the MySQL native connector.

Use the Table Filter dialog to select the Beta schema and the table(s)
therein ONLY.

Close and reopen the Base file.

In the tables section now there is still an entry for both schema, Alpha
with zero tables listed and Beta with all the tables listed.
When multiple schema are displayed they are displayed in alphabetical order.
(Issue 1?)

Use the table editor or table wizard to create a new table.
When you go to save the table design there is a drop down to select the
schema to save it to.
This drop down defaults to the first schema listed - in this case Alpha.
(Issue 2? of course if Issue 1 is an issue and it where fixed I suppose
this one goes away)

Well - there you go,

Drew

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[Frank Schoenheit, Sun Microsystems Germany]

Hi Drew,

> In the tables section now there is still an entry for both schema, Alpha
> with zero tables listed and Beta with all the tables listed.

Issue 1, probably. Would you want to see Alpha when there's no
(accessible) table? Probably not.

> When multiple schema are displayed they are displayed in alphabetical order.
> (Issue 1?)

What other order would you consider more natural?
Or does your "Issue 1?" here refer to Alpha being listed.

> Use the table editor or table wizard to create a new table.
> When you go to save the table design there is a drop down to select the
> schema to save it to.
> This drop down defaults to the first schema listed - in this case Alpha.
> (Issue 2? of course if Issue 1 is an issue and it where fixed I suppose
> this one goes away)

I'd say this should default to the schema which was used to connect the
the DB. (Technically, this might be difficult, so I shouldn't say this
too loud.)

Ciao
Frank

--
- Frank Schönheit, Software Engineer         frank.schoenheit@... -
- Sun Microsystems                      http://www.sun.com/staroffice -
- OpenOffice.org Base                       http://dba.openoffice.org -
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[drewjensen]

> Issue 1, probably. Would you want to see Alpha when there's no
> (accessible) table? Probably not.
>
>  
>> When multiple schema are displayed they are displayed in alphabetical order.
>> (Issue 1?)
>>    
>
> What other order would you consider more natural?
> Or does your "Issue 1?" here refer to Alpha being listed.
>  

yes it refers to the visibility - not the order.


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...