Skip site navigation (1) Skip section navigation (2)

Re: Altering Database/Table Ownership

From: Darren Ferguson <darren(at)crystalballinc(dot)com>
To: Jillian Carroll <jillian(at)koskie(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Altering Database/Table Ownership
Date: 2002-04-30 19:57:54
Message-ID: Pine.LNX.4.10.10204301554500.27379-100000@thread.crystalballinc.com (view raw or flat)
Thread:
Lists: pgsql-general
Have you logged into Postgres as the System Administration account or your
account has system admin privelges??

create table test(number integer null);
CREATE
test=# \d
  List of relations
 Name | Type  | Owner 
------+-------+-------
 test | table | vlad
(1 row)


test=# alter table test owner to nobody;
ALTER
test=# \d
   List of relations
 Name | Type  | Owner  
------+-------+--------
 test | table | nobody
(1 row)

test=# select version();
                           version                           
-------------------------------------------------------------
 PostgreSQL 7.2.1 on i686-pc-linux-gnu, compiled by GCC 2.96
(1 row)

HTH

Darren Ferguson

On Tue, 30 Apr 2002, Jillian Carroll wrote:

> How can I do this?
> 
> ALTER TABLE users OWNER TO smith
> 
> Isn't working.
> 
> Can anybody point me in the right direction?  I can't find anything other
> than this in the docs or on Deja.
> 
> Thanks!
> 
> --
> Jillian
> 


In response to

pgsql-general by date

Next:From: Andrew SullivanDate: 2002-04-30 20:34:24
Subject: Re: [HACKERS] Re : Solaris Performance - 64 bit puzzle
Previous:From: Tom LaneDate: 2002-04-30 19:28:13
Subject: Re: [HACKERS] Re : Solaris Performance - 64 bit puzzle

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group