Hi Der-Ping,
Using the new model, I encountered a problem when developing ASA/ASE enablement catalog loaders. So I'm eager to see the sample catalog loader code for the new access control models:)
In the new model, we have the following bidirectional relationships:
SQLObject.privilege <--> Privilege.object and Privilege.grantee <--> AuthorizationIdentifier.receivedPrivileges
So in a SQLObject catalog loader, say, XXXCatalogTable, when I load the table's privileges, I need to call Privilege.setGrantee to associate the privilege with the AuthorizationIdentifier. This causes the AuthorizationIdentifier to load the receivedPrivileges since it's a bidirectional link, and in the AuthorizationIdentifier's catalog loader, I also need to call Privilege.setObject, which causes XXXCatalogTable.getPrivileges to run again and results in a dead loop.
Hope I've made it clear. Thanks!
Best Regards!
Max (Hui) Cao
Sybase Shanghai RD
-----dtp-dev-bounces@xxxxxxxxxxx wrote: -----
To: DTP development mailing list <dtp-dev@xxxxxxxxxxx>
From: Der Ping Chou <dpchou@xxxxxxxxxx>
Sent by: dtp-dev-bounces@xxxxxxxxxxx
Date: 05/31/2007 12:45PM
cc: DTP development mailing list <dtp-dev@xxxxxxxxxxx>, dtp-dev-bounces@xxxxxxxxxxx
Subject: Re: [dtp-dev] [dtp] Access Control Package check in - 185822
Anil,
Since the Access Control Package change
in SQLModel would impact any derived/specialized model based on SQLModel.
Derby model is one of the derived/specialized model, therefore it has been
re-generated. Hence, I ran a quick BVT to ensure Derby connection/DSE works.
As for the details for Access Control
Package change proposal please see following modelbase link (scroll to
the bottom of the page) or zip file attached with in BZ185822 :
http://wiki.eclipse.org/index.php/Model_Base
Sample and exemplary code for the Access
Control Package will be contributed later to help the adoption.
Hope this help.
Der-Ping Chou
Information Management Tooling
Development Manager - Data Tools
Seattle IBM Office
tel : 1-206-587-5946 (T/L: 277-5946)
fax: 1-206-587-4415
Anil Samuel <anil.samuel@xxxxxxxxxx>
Sent by: dtp-dev-bounces@xxxxxxxxxxx
05/30/2007 05:34 PM
|
Please respond to
DTP development mailing list <dtp-dev@xxxxxxxxxxx>
|
|
|
To
| DTP development mailing list <dtp-dev@xxxxxxxxxxx>
|
|
cc
|
|
|
Subject
| Re: [dtp-dev] [dtp] Access Control Package
check in - 185822
|
|
Hi Der-Ping
Could you explain this with respect to the attached image
? Sorry I may have missed previous threads on this topic.
Regards
Anthos
On 31/05/2007, at 10:29 AM, Der Ping Chou wrote:
Verified with Derby database:
https://bugs.eclipse.org/bugs/show_bug.cgi?id=185822
<mime-attachment.gif>
John, Sybase ASA model was also updated, please verify the result and let
me know if there is any problem?
Thanks,
Der-Ping Chou
Information Management Tooling
Development Manager - Data Tools
Seattle IBM Office
tel : 1-206-587-5946 (T/L: 277-5946)
fax: 1-206-587-4415
<mime-attachment.gif>
_______________________________________________
dtp-dev mailing list
dtp-dev@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/dtp-dev
_______________________________________________
dtp-dev mailing list
dtp-dev@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/dtp-dev
_______________________________________________
dtp-dev mailing list
dtp-dev@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/dtp-dev
