How can I assign a limit in creating database for a specific user

To do this using QSL you would first need to put the information required in to the database. i.e. a list of users and how many db's each has opened.
Doing it with SQL is probably not the best approach, but could be made to work, but only if you provide the required data first.