SQL Anywhere Feedback - Groups in sybase central

Author

Groups in sybase central

Toma¾ Kralj

2005-09-01, 1:23 pm

Hi!

I would like to see option to create groups in Sybase Central. I would like
to group some procuders, functions, tables ... in some logical groups. Just
to be better organized and to easier find my objects.

Regards

Tomaz

Greg Fenton

2005-09-01, 8:23 pm

Toma¾ Kralj wrote:
>
> I would like to see option to create groups in Sybase Central. I would like
> to group some procuders, functions, tables ... in some logical groups. Just
> to be better organized and to easier find my objects.

This is available today. This is exactly what you can do with different
database users and/or groups (a group in ASA is actually just a special
characteristic of an ASA user).

Then, in SC, you can filter your view to just those objects of a
particular user.

Does this help?

greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/

Russell Fleming

2005-09-01, 8:23 pm

What about procedures/functions placed in a functionality or application
scope container? Like an Oracle package header and body.

"Greg Fenton" <greg. fenton_NOSPAM_@ianyw
here.com> wrote in message
news:43175706$1@foru
ms-1-dub...
> Toma¾ Kralj wrote:
like[color=darkred]
Just[color=darkred]
>
> This is available today. This is exactly what you can do with different
> database users and/or groups (a group in ASA is actually just a special
> characteristic of an ASA user).
>
> Then, in SC, you can filter your view to just those objects of a
> particular user.
>
> Does this help?
>
> greg.fenton
> --
> Greg Fenton
> Consultant, Solution Services, iAnywhere Solutions
> --------
> Visit the iAnywhere Solutions Developer Community
> Whitepapers, TechDocs, Downloads
> http://www.ianywhere.com/developer/

Greg Fenton

2005-09-02, 3:24 am

Russell Fleming wrote:
> What about procedures/functions placed in a functionality or application
> scope container? Like an Oracle package header and body.
>

I like working with Oracle packages, but I don't see that the user/group
approach still does not fit this model. Create an ASA user or group
where in Oracle you would create a package. Grant permissions on that
user/group in the same way you'd grant access to the Oracle package.

greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/

Tomaz Kralj

2005-09-02, 9:23 am

No, this is not what I would like to have.
When I develop application I would like to have option to se just
procedures, tables for this application. Not to filter them, but to make
groups of objects.

Or, If I work on invoicing application, I would like to see in one container
everything that is for this subject

Regards

Tomaz

"Greg Fenton" <greg. fenton_NOSPAM_@ianyw
here.com> je napisal v sporocilo
news:43175706$1@foru
ms-1-dub ...
> Toma¾ Kralj wrote:
>
> This is available today. This is exactly what you can do with different
> database users and/or groups (a group in ASA is actually just a special
> characteristic of an ASA user).
>
> Then, in SC, you can filter your view to just those objects of a
> particular user.
>
> Does this help?
>
> greg.fenton
> --
> Greg Fenton
> Consultant, Solution Services, iAnywhere Solutions
> --------
> Visit the iAnywhere Solutions Developer Community
> Whitepapers, TechDocs, Downloads
> http://www.ianywhere.com/developer/

Greg Fenton

2005-09-02, 11:23 am

Tomaz Kralj wrote:
>
> Or, If I work on invoicing application, I would like to see in one container
> everything that is for this subject
>

I'm not clear as to how users/groups does not accomplish this. Create a
user called "invoicing", create tables ("invoicing"."t1",
"invoicing"."t2"), create procedures ("invoicing"."sp_1", ...), etc...

Then in Sybase Central, you can change the filter to show only
"invoicing" objects. As you look in the table folder, the procedure
folder, etc... you would only see "invoicing" objects.

Or are you asking for a way to see, in one "folder", all of the objects
belonging ton one user/group?

greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/

Breck Carter [TeamSybase]

2005-09-02, 1:23 pm

I don't think he wants to filter them out completely, I think he wants
extra level(s) in the treeview hierarchy in the left pane to show and
hide groupings of objects by some arbitrary categorization. I'm not
sure how this would be designed, but I suspect groups and ownerships
might not be up to the task (too much setup required). Think 1000
tables, similar numbers of triggers, etc. It's not a feature that
would make much difference for 10 or even 100 tables but would be
useful for the monster schemas.

It is worth pursuing as an idea, IMO. SQL Anywhere is moving into the
world of scalable enterprise databases, and in that world you do find
monster schemas. Graphical tools like PowerDesigner simply don't
scale, but a text based display like Sybase Central does...
nevertheless, some help might be in order.

Breck

On 2 Sep 2005 07:42:59 -0700, Greg Fenton
<greg. fenton_NOSPAM_@ianyw
here.com> wrote:

>Tomaz Kralj wrote:
>
>I'm not clear as to how users/groups does not accomplish this. Create a
>user called "invoicing", create tables ("invoicing"."t1",
>"invoicing"."t2"), create procedures ("invoicing"."sp_1", ...), etc...
>
>Then in Sybase Central, you can change the filter to show only
>"invoicing" objects. As you look in the table folder, the procedure
>folder, etc... you would only see "invoicing" objects.
>
>Or are you asking for a way to see, in one "folder", all of the objects
>belonging ton one user/group?
>
>greg.fenton

--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/A...7/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com

Tomaz Kralj

2005-09-02, 8:23 pm

Greg, I'am not talking about users and their groups.

I'am talking about organzation of database objects(tables, triggers...).

Example:
When I click in right site on tables I would like to have more levels which
I could create. So I would create one level for tables which I use for
Invoicing. Maybe I would need another level under invoicing...

The same for triggers, procedures...

I hope you understand me

Tomaz

"Greg Fenton" <greg. fenton_NOSPAM_@ianyw
here.com> je napisal v sporocilo
news:431864ef$1@foru
ms-2-dub ...
> Tomaz Kralj wrote:
>
> I'm not clear as to how users/groups does not accomplish this. Create a
> user called "invoicing", create tables ("invoicing"."t1",
> "invoicing"."t2"), create procedures ("invoicing"."sp_1", ...), etc...
>
> Then in Sybase Central, you can change the filter to show only "invoicing"
> objects. As you look in the table folder, the procedure folder, etc...
> you would only see "invoicing" objects.
>
> Or are you asking for a way to see, in one "folder", all of the objects
> belonging ton one user/group?
>
> greg.fenton
> --
> Greg Fenton
> Consultant, Solution Services, iAnywhere Solutions
> --------
> Visit the iAnywhere Solutions Developer Community
> Whitepapers, TechDocs, Downloads
> http://www.ianywhere.com/developer/

Kjetil Valøy

2005-09-06, 7:23 am

I wrote this earlier in august:

"
I would also like a possibillity to right click on Tables or Procedure
& Functions and chose "show/open in new window" That way I could have
both Tables and P/F opened in separat windows for one database.

Also the possibillity to make groops that P/F belong to so it would be
possible to filter and just show P/F (even tables) that belong to that
group. That way I could have a window with all procedures and tables
belonging to one groop opened together. It would be greate!

We have about 320 tables and 850 tables in one of our databases.
"

The reason I think groups does not work is that one procedure/table
should be able to exist in several groups. Because it is used by
several functionalities.

--- Kjetil Valøy ---

On 1 Sep 2005 11:18:18 -0700, "Toma¾ Kralj" <tomaz@soft4you-sp.si>
wrote:

>Hi!
>
>I would like to see option to create groups in Sybase Central. I would like
>to group some procuders, functions, tables ... in some logical groups. Just
>to be better organized and to easier find my objects.
>
>Regards
>
>Tomaz
>
>

Martin Baur

2005-09-06, 1:23 pm

In article <431d6bf3.526469713@forums.sybase.com>, __no_spam__kjetil.valoy@iticket.no says...
> I wrote this earlier in august:
>
> "
> I would also like a possibillity to right click on Tables or Procedure
> & Functions and chose "show/open in new window" That way I could have
> both Tables and P/F opened in separat windows for one database.

I also strongly support this.

I suggest that Central allows "Show in separate window" for all top lebel tree entries in the menu, so:

Under the db, all items like tables, users, triggers .. klicking on tables opens a new windows showing all tables. This way, I can compare the structure of two tabels on two different databases or
even servers. I do this regularly on my staging and my productive server. My schema currently has abuot 50 tables. Central can no longer show me all tables on one screen. I therefore would like to
have multiple "table" windows to arrange them to see waht I need.

Whether we go down to a subitem (e.g. a single table) is not that important to me.

However, I also think that for large schemas, there should be some elemt to structure the view to them.

FWIW.

Martin

Sponsored Links