Changing SQL account password in specific database
All password authentication for userid is at the server level for a login.  Therefore the LionsDB database will have users but does not have per database password for those users since the login is the authentication point.

If you have enough rights, you can change the passwords of the logins and use a different password, but that password would be the same for all databases on your server.

If you need a special login for a database, then you should create another login, e.g. LionsDB_George or some such pattern that suits you.  Then you grant that login rights to the LionsDB database.