Welcome to the Java Programming Forums


The professional, friendly Java community. 21,500 members and growing!


The Java Programming Forums are a community of Java programmers from all around the World. Our members have a wide range of skills and they all have one thing in common: A passion to learn and code Java. We invite beginner Java programmers right through to Java professionals to post here and share your knowledge. Become a part of the community, help others, expand your knowledge of Java and enjoy talking with like minded people. Registration is quick and best of all free. We look forward to meeting you.


>> REGISTER NOW TO START POSTING


Members have full access to the forums. Advertisements are removed for registered users.

Results 1 to 2 of 2

Thread: How to allow users to create / alter / drop tables in another users schema in Derby?

  1. #1
    Junior Member
    Join Date
    Sep 2012
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default 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


  2. #2
    Super Moderator copeg's Avatar
    Join Date
    Oct 2009
    Location
    US
    Posts
    5,235
    Thanks
    176
    Thanked 817 Times in 760 Posts
    Blog Entries
    5

    Default Re: How to allow users to create / alter / drop tables in another users schema in Der

    Look into the GRANT command...
    GRANT statement

Similar Threads

  1. Hello Java users!
    By Sagittarian in forum Member Introductions
    Replies: 0
    Last Post: June 1st, 2012, 01:45 PM
  2. Generate users id
    By sante in forum Algorithms & Recursion
    Replies: 5
    Last Post: October 6th, 2011, 11:29 AM
  3. java and blind users
    By micam001 in forum Member Introductions
    Replies: 1
    Last Post: June 27th, 2011, 03:27 AM
  4. create some fake users on server
    By nakres in forum Paid Java Projects
    Replies: 1
    Last Post: March 25th, 2011, 10:37 AM
  5. How to Get users home directory
    By JavaPF in forum Java Code Snippets and Tutorials
    Replies: 0
    Last Post: September 2nd, 2010, 10:37 AM

Tags for this Thread