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

Re: [SQL] SQL Things

From: De Moudt Walter <wdemoudt(at)planetinternet(dot)be>
To: Neil Cameron <n(dot)cameron(at)blueice(dot)co(dot)uk>
Cc: pgsql-sql(at)postgreSQL(dot)org
Subject: Re: [SQL] SQL Things
Date: 2000-01-21 23:50:09
Message-ID: 3888F0B1.DA4D2E61@planetinternet.be (view raw or flat)
Thread:
Lists: pgsql-sql
Neil,
You can grant/revoke rights users have with the grant or revoke command:

> GRANT select, insert, delete, update ON table_name TO user1, user2,..

> REVOKE create FROM user1
The first example grants the rights to view and update tables to user1
and user2, while the second example tells that user1 is not allowed to
create a table. How to change the default behaviour, i don't know at
first glance.
This is basic SQL.

Hope it helps,

De Moudt Walter

> Neil Cameron wrote:
> 
> Hi
> 
> Two questions.
> 
> 1. How can I change a database object's owner using SQL type commands
> ?
> 2. Users seem by default to be able to create tables. Is this correct.
> If so how can we remove this right.
> 
> Neil(at)blueice

In response to

  • SQL Things at 2000-01-22 01:14:27 from Neil Cameron

pgsql-sql by date

Next:From: Neil CameronDate: 2000-01-22 01:14:27
Subject: SQL Things
Previous:From: Tom LaneDate: 2000-01-21 18:38:10
Subject: Re: [SQL] DISTINCT and aggregates

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