Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Multiuser with ability to create and drop own DBs, but not others

Status
Not open for further replies.

Guest_imported

New member
Jan 1, 1970
0
i'm using Mysql 3.23 and need to create several users, all of which need the ability to create and delete their own databases, but they should not be able to see other people's databases.

How is this possible? Can it be done with privileges alone?

I know i can create databases for people and then give them permissions on each database individually, but ideally the users need to be able to create and delete their own databases without having the ability to do it to everyone elses.

Any suggestions are very much appreciated :)

Thanks in advance!

fishsponge
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top