Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: pass (hermes.apache.org: domain of jta@bristowhill.com
 designates 66.75.162.133 as permitted sender)
Message-ID: <42362D3B.20104@bristowhill.com>
Date: Mon, 14 Mar 2005 16:32:59 -0800
From: "Jean T. Anderson" <jta@bristowhill.com>
User-Agent: Mozilla Thunderbird 0.9 (X11/20041127)
MIME-Version: 1.0
To: Derby Discussion <derby-user@db.apache.org>
Subject: Re: GRANT all on .... to public; style in Derby  ?
References: 
 <1B37BEFB3456F1428E01932AFA147822E1A5E7@HOUEXCH902.landmark.lgc.com>
 <002701c528e5$b94d7450$e3118780@skate>
In-Reply-To: <002701c528e5$b94d7450$e3118780@skate>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Dan Debrunner did a helpful presentation on "Securing Data with Apache 
Derby" at the November ApacheCon US.  The presentation is available for 
download from here:

http://incubator.apache.org/derby/papers/ApacheConUs04.html

  -jean

Jonathan Eric Miller wrote:
> I'm in the process of trying to figure that out myself. To my knowledge 
> there isn't a SQL GRANT statement. However, I think there are properties 
> that you can set using a system stored procedure if I remember 
> correctly. Like I said, I still haven't really figured this out for 
> myself, so, maybe I'm wrong... I used the following to grant full access 
> to a database for a user. Not sure how granular you can get with Derby's 
> security...
> 
> CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY(
> 'derby.database.fullAccessUsers',
> '<userNameToBeGrantedFullAccess>'
> );
> 
> Jon
> 
> ----- Original Message ----- From: "Bernd Ruehlicke" <BRuehlicke@lgc.com>
> To: "Derby Discussion" <derby-user@db.apache.org>
> Sent: Monday, March 14, 2005 12:46 PM
> Subject: GRANT all on .... to public; style in Derby ?
> 
> 
> Anyone knows if Derby has a similar concept as "GRANT" in Oracle ?
> 
> B-)