[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...
Live a little! The night is young! And we have umbrellas in our drinks! This umbrella has a tiny ad:
Why should you try IntelliJ IDEA ?
https://coderanch.com/wiki/696337/IntelliJ-IDEA


This thread has been viewed 1893 times.

All times above are in ranch (not your local) time.
The current ranch time is
Aug 22, 2018 00:17:47.