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

15 Mar 2005 00:33:27 -0000

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" <[EMAIL PROTECTED]>
To: "Derby Discussion" <[email protected]>
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-)

Reply via email to