Re: Limiting user privileges

Поиск
Список
Период
Сортировка
От Tad Marko
Тема Re: Limiting user privileges
Дата
Msg-id 1105475175.8275.7.camel@boojiboy.metrosplash.com
обсуждение исходный текст
Ответ на Re: Limiting user privileges  (Michael Fuhr <mike@fuhr.org>)
Ответы Re: Limiting user privileges
Список pgsql-admin
On Mon, 2005-01-10 at 11:31 -0700, Michael Fuhr wrote:
> On Mon, Jan 10, 2005 at 11:19:10AM -0600, Tad Marko wrote:
> ... earlier comments regarding schemas and privileges ...

Now I'm a bit closer to having things working, but I seem to be running
into another problem granting the privileges I want for a given user.

I can

GRANT ALL ON a_specific_table TO user

but I can't figure out how to simply give some privilege to a user on
all tables.

I'm pretty sure that I don't have my head wrapped around schemas well
enough, so maybe what I ought to be asking is how do I create a database
in a new schema and then use the schema to control user access???

Thanks,
Tad
--
Tad Marko <tmarko@metrosplash.com>


В списке pgsql-admin по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Vacuum full - disk space eaten by WAL logfiles
Следующее
От: "BASEI, Sidnei R."
Дата:
Сообщение: PostgreSQL Performance