My Oracle Support Banner

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 OCTOBER 10, 2022

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

To view full details, 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 a vibrant support community of peers and Oracle experts.