db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jonathan Eric Miller" <jemil...@uchicago.edu>
Subject Re: GRANT all on .... to public; style in Derby ?
Date Mon, 14 Mar 2005 22:32:36 GMT
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