Yes, DB Users peice of security will be good. But keep in mind, you still have to deal with Logins at the Instance level in secondary replicas.