db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dimple Bhatia" <dim...@gmail.com>
Subject Creating tables in a new schema with sqlAuthorization set to true
Date Fri, 30 Nov 2007 23:08:32 GMT
I see that when connection.requireAuthentication and sqlAuthorization are
set to true in the derby.properties, only the database owner can create a
table in a schema that does not exist( which means creating a new schema).
DB2 does allow users to create tables in a different schema if the schema
does not exist. Just wondering if there was any specific reason , this is
blocked in Derby. Pls. let me know. Thanks

View raw message