How to allow users to create / alter / drop tables in another users schema in Derby?
Hi.
Do you know any way to allow users to create / alter / drop tables in a common schema created by the database owner in Derby database?
Is there any way to grant schema permissions to more users?
My application has user authentication and creates tables dynamically. Sometimes software updates need to create / alter / drop tables, but only the schema owner has the right to do it now. But it would be very uncomfortable to request administrator password by every software update that needs to change tables.
Thanks.
JHead
Re: How to allow users to create / alter / drop tables in another users schema in Der
Look into the GRANT command...
GRANT statement