[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...

This thread has been viewed 1942 times.

All times above are in ranch (not your local) time.
The current ranch time is
Nov 13, 2018 16:05:12.