[Logo]
Forums Register Login
creating a new user profile dynamically for mysql?
I have created a database (say A). Now i want to create a new privileged user which can access the database using a given form...i.e. after the new user fills in his details...he should be given a complete access to all the data in the database..like inserting, updating all...how to do that in java implementation...I know how to create a new database..but how to create a new user on that database..??
JDBC isn't meant for database admin. Maybe you could use Runtime.exec and execute the command line to add a user?
 

Jeanne Boyarsky wrote:JDBC isn't meant for database admin. Maybe you could use Runtime.exec and execute the command line to add a user?




can you please elaborate a bit further on how to implement it??? thanks a lot...
See the runtime.exec article. You just have to know how to add a user from the command line for this to work.
 

Jeanne Boyarsky wrote:See the runtime.exec article. You just have to know how to add a user from the command line for this to work.




thanks a lot for that...i tried doing it my conventional jdbc methods and i was able to create a new user...However for that user to be active I had to go through the command line...
Tell me how it all turns out. Here is a tiny ad:
ScroogeXHTML 7.1 - RTF to HTML5 / XHTML converter
https://coderanch.com/t/690611/ScroogeXHTML-RTF-HTML-XHTML-converter


This thread has been viewed 1778 times.

All times above are in ranch (not your local) time.
The current ranch time is
Feb 18, 2018 01:59:28.