View is dropped all grants of object privileges are revoked from roles & users

Discussion

• Nirja Shah   -Posted on 29 Sep 15
  - To replace a view, you must have all of the privileges required to drop and create a view.
  
  - If the definition of a view must change, the view must be replaced.
  
  - You cannot use an ALTER VIEW statement to change the definition of a view.
  
  - When a view is dropped, all grants of corresponding object privileges are revoked from roles and users.
  
  - After the view is re-created, privileges must be regranted.
  
  - You can replace views in the following ways:
  
  1. You can drop and re-create the view.
  
  2. You can redefine the view with a CREATE VIEW statement that contains the OR REPLACE clause.
  - The OR REPLACE clause replaces the current definition of a view and preserves the current security authorizations.

➨ Post your comment / Share knowledge