Is there a way to give a specific database role in one database an access to another database within the same server? I though perhaps I can grant DB2 database access to the "DBUsers" database role in DB1 database so all the users that are members of this role will automatically have access to the DB2 database. Can this be done? TIA.
It's "my" world. You're just living in it.