db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jean T. Anderson" <...@bristowhill.com>
Subject Re: GRANT all on .... to public; style in Derby ?
Date Tue, 15 Mar 2005 00:32:59 GMT
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-)


Mime
View raw message