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 NOVEMBER 22, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.2 and later
Information in this document applies to any platform.

Goal

 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?

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms