<div>
As long as you create or replace view, existing grants remain in place. &nbsp;No need to regrant permissions.
</div>


As long as you create or replace view, existing grants remain in place.  No need to regrant permissions.

<div>
Thanks Slighwv - I do have create or replace statement - does that mean the replace will replace the grants are well?
</div>


Thanks Slighwv - I do have create or replace statement - does that mean the replace will replace the grants are well?

<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
I have existing view in oracle that I am altering and adding some columns - the existing view has grants in the script - after my alter view should I regrant the views or dont have to re-grant - how does that work?
</div>
</div>


Hi

I have existing view in oracle that I am altering and adding some columns - the existing view has grants in the script - after my alter view should I regrant the views or dont have to re-grant - how does that work?

views and grants

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.