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-)
