Can I prevent Oracle users from creating public synonyms but allow private ones?

Posted by ninesided on Server Fault See other posts from Server Fault or by ninesided
Published on 2010-04-09T09:16:04Z Indexed on 2010/04/09 9:23 UTC
Read the original article Hit count: 200

I've had a few issues where users have mistakenly created public synonyms which have led to people thinking some objects are in one schema when they're actually in another schema. Everyone knows they should be using private synonyms, but occasionally they forget or they make a mistake and someone gets burned. Is it possible to GRANT users the permission to create private synonyms but disallow public ones?

© Server Fault or respective owner

Related posts about Oracle

Related posts about database-permissions