Home » SQL & PL/SQL » SQL & PL/SQL » How to replace the view with Previledges (Oracle 9i)
How to replace the view with Previledges [message #315137] Sat, 19 April 2008 07:23 Go to next message
spmano1983
Messages: 269
Registered: September 2007
Senior Member
Friends,

I have one view view1 with preveledges. Now i want add one column to this view. If i want to add, then should i recreate the view right? If so, i want recreate the previledges again? So, how i can replace the view with affecting the previledges?
Any possible ideas?

Thanks
Mano
Re: How to replace the view with Previledges [message #315138 is a reply to message #315137] Sat, 19 April 2008 07:36 Go to previous messageGo to next message
dhananjay
Messages: 635
Registered: March 2002
Location: Mumbai
Senior Member
Use the CREATE or REPLACE view view_name as with the new column you wanted.


regards,
Re: How to replace the view with Previledges [message #315161 is a reply to message #315138] Sat, 19 April 2008 09:19 Go to previous message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Unlike procedure "create or replace" on view does not keep the privileges (at least in all versions I tested it).

Edit: but it does it in the latest versions.

Regards
Michel

[Updated on: Sat, 19 April 2008 09:21]

Report message to a moderator

Previous Topic: Join Algorthim
Next Topic: Problem when cursor returning a table name
Goto Forum:
  


Current Time: Sun Dec 11 04:37:01 CST 2016

Total time taken to generate the page: 0.08058 seconds