How to grant object privileges of all the objects under a particular Schema? Is it possible grant object privileges at schema level?
(Doc ID 312167.1)
Last updated on FEBRUARY 02, 2020
Applies to:Oracle Database - Enterprise Edition - Version 10.1.0.2 and later
Information in this document applies to any platform.
Is there a way to grant privileges like 'select', 'insert' and 'execute' by SCHEMA name to an individual user? This would avoid creating a script that lists every object in the schema. Also this would give the user the privilege to any objects added to the schema in the future. Is there a way to grant privileges like 'alter' and 'create' by SCHEMA name to a user?
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!