How to grant object privileges of all the objects under a particular Schema? Is it possible grant object privileges at schema level?
Last updated on NOVEMBER 22, 2016
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?
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms