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

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 (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-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

pgsql-novice by date

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

pgsql-general by date

Next:From: Greg SmithDate: 2010-02-18 09:04:47
Subject: Re: about effective_cache_size
Previous:From: A. KretschmerDate: 2010-02-18 08:47:18
Subject: Re: about effective_cache_size

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