Synonyms for groups of users
HI,
I'm not sure you can do what I'm attempting - as what I've seen elsewhere is not quite what I'm looking for.
I have a database that has a number of different application schemas. One holds legacy information that I don't want updating. I have a number of users that need to connect to it for BI purposes.
I was going along the idea of granting select on all the tables in that schema to a role, then assigning the roles to the individual users.
The problem comes with assigning synonyms to those users. It would be easier and tidier if we were able to somehow assign to the role rather than using public or private synonyms of the users. I don't think there will be a huge body of people who will need this, but there are a lot of objects to reference. I'd prefer if they weren't public synonyms.