Solved

views and grants

Posted on 2012-03-23
3
391 Views
Last Modified: 2012-03-23
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?
0
Comment
Question by:mahjag
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 37757171
As long as you create or replace view, existing grants remain in place.  No need to regrant permissions.
0
 

Author Comment

by:mahjag
ID: 37757862
Thanks Slighwv - I do have create or replace statement - does that mean the replace will replace the grants are well?
0
 
LVL 77

Accepted Solution

by:
slightwv (䄆 Netminder) earned 150 total points
ID: 37757873
No.  Replace only replaces that specific object.  Grants do not need 'replaced'.  The grants will remain as they are as long as the object is never dropped.
0

Featured Post

Enroll in June's Course of the Month

June’s Course of the Month is now available! Experts Exchange’s Premium Members, Team Accounts, and Qualified Experts have access to a complimentary course each month as part of their membership—an extra way to sharpen your skills and increase training.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

691 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question