db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Hiranya Jayathilaka <hiranya...@gmail.com>
Subject Re: Roles Support for dblook
Date Sun, 19 Jul 2009 11:14:57 GMT
One more question.
We initially intended to use a dependency graph to capture the dependencies
among different roles. But looking at the SYSROLES table and the existing
role handling code I'm not sure whether we really need that. Isn't creating
all the roles in one swoop and then performing all the grants (also recorded
in SYSROLES table) sufficient? I can't seem to realize how this will break
any inter-dependencies among roles.

On Sun, Jul 19, 2009 at 4:21 PM, Hiranya Jayathilaka

> Hi Folks,
> I'm now into implementing roles support for the improved dblook
> implementation. Current dblook implementation simply creates all the roles
> and does the necessary role grants, before start creating other persistent
> objects. I guess I could do the same reusing most if not all of the existing
> code. However I think in the new implementation we need to capture the
> dependency a persistent object may have on a role. Can somebody please let
> me know where these dependencies are recorded? Is it in the SYSDEPENDS?
> Secondly we need to set the necessary role before going on to creating any
> object. What is the SQL for this? Is it something like SET ROLE {ROLENAME}?
> Also I guess I might have to 'unset' roles after creating an object? Is that
> correct?
> Thanks,
> Hiranya Jayathilaka

Hiranya Jayathilaka
Software Engineer;
WSO2 Inc.;  http://wso2.org
E-mail: hiranya@wso2.com;  Mobile: +94 77 633 3491
Blog: http://techfeast-hiranya.blogspot.com

View raw message