Granting synonyms to a role
SamBFeb 4 2007 — edited Feb 4 2007I know it is not possible (at least in 9i) to directly grant synonyms to a role. My question relates to how it is best to implement such a feature using plsql. Basically, I have a list of synonyms associated with a particular role and when I create new users I want to only reference the name of the role and the synonyms associated with that role should be created automatically.
I know I can create a table to maintain such a list but I have a feeling the data dictionary may already have the information I need and I would prefer it if this procedure did not rely on any other tables.