Define permissions at database level

From: dipti shah <shahdipti1980(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org, pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: Define permissions at database level
Date: 2010-02-18 08:53:20
Message-ID: d5b05a951002180053t61b87724pa167449b558a520d@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-novice

Hi,

Is it possible to define the permissions at database level such that no
users(except postgres) can execute DROP, ALTER, TRUNCATE commands directily?
Users have to use the given stored procedures.

Thanks,
Dipti

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Greg Smith 2010-02-18 09:04:47 Re: about effective_cache_size
Previous Message A. Kretschmer 2010-02-18 08:47:18 Re: about effective_cache_size

Browse pgsql-novice by date

  From Date Subject
Next Message Richard Huxton 2010-02-18 10:04:50 Re: Define permissions at database level
Previous Message Greg Sabino Mullane 2010-02-17 20:07:35 Re: check_postgres