How can I create a user who has access to only one database but has complete access to that database and can create and drop objects, select, insert and drop rows.
As mentioned you grant db_owner right to a particular user for an specific database. Note that you won’t be able to see and handle sql server agent jobs
