Database Administration (MOSC)

MOSC Banner

Synonyms for groups of users

edited Dec 22, 2017 4:01AM in Database Administration (MOSC) 14 commentsAnswered

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center