GRANT all on .... to public; style in Derby ?

[Bernd Ruehlicke <BR...@lgc.com>]

Anyone knows if Derby has a similar concept as "GRANT" in Oracle ?
 
B-)

Re: GRANT all on .... to public; style in Derby ?

["Jean T. Anderson" <jt...@bristowhill.com>]

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" <BR...@lgc.com>
> To: "Derby Discussion" <de...@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-)

Re: GRANT all on .... to public; style in Derby ?

[Jonathan Eric Miller <je...@uchicago.edu>]

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" <BR...@lgc.com>
To: "Derby Discussion" <de...@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-)