Postgres ownership rules?

Reply

•
•
Join Date: Aug 2006
Posts: 999
Reputation: EnderX is an unknown quantity at this point 
Solved Threads: 1
EnderX EnderX is offline Offline
Posting Shark

Postgres ownership rules?

 
0
  #1
Sep 27th, 2006
Does anyone know how to change the ownership of a view in a postgres database? I have no clue how to do so, and all of the solutions I've seen so far online don't want to work for me.

Thanks in advance,
-EnderX
Reply With Quote Quick reply to this message  
•
•
Join Date: Oct 2005
Posts: 523
Reputation: pty is on a distinguished road 
Solved Threads: 37
pty's Avatar
pty pty is offline Offline
Posting Pro

Re: Postgres ownership rules?

 
0
  #2
Sep 28th, 2006
•
•
•
•
Originally Posted by EnderX View Post
Does anyone know how to change the ownership of a view in a postgres database? I have no clue how to do so, and all of the solutions I've seen so far online don't want to work for me.

Thanks in advance,
-EnderX
ALTER TABLE vw_my_view OWNER TO pty;
Note to self... pocket cup
Reply With Quote Quick reply to this message  
Reply

Quick Reply to Thread
This thread is more than three months old.
Perhaps start a new thread instead?
•
•
•
•
•
•
•
•
Message:
•
•
•
•



Similar Threads
Other Threads in the Database Design Forum


Views: 2195 | Replies: 1
Thread Tools Search this Thread



Tag cloud for Database Design
assignment avatar backup bigbrother business calendar daniweb data database databasedesign design erd europe events hacker hp ibm medicine mobilephone mysql news recovery security server sql survey uk update
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC