So accoriding to the above logic. I have to Deny View Any DB first. THen make the login owner of the DB. Then it will be not be able to access all the DBs but it will be able to view the DB that it is the part of? Right?

There are two issues here:

1> I donot want the login to have owner permissions on the DB I want the login to have minimal permissions.

2> What if I want to do this for 2 or more logins? Since I can have only one login as a owner I can not accomedate all the logins.

Is there any work aroud other than making the login Owner of the DB?