Re: permissions on databases

Поиск
Список
Период
Сортировка
От Brett W. McCoy
Тема Re: permissions on databases
Дата
Msg-id Pine.LNX.4.30.0102061213240.6219-100000@chapelperilous.net
обсуждение исходный текст
Ответ на permissions on databases  (Tressens Lionel <tressens@etud.insa-tlse.fr>)
Список pgsql-general
On Tue, 6 Feb 2001, Tressens Lionel wrote:

> I am the super user of my DBMS and if create a database for a simple user,
> I do :
>
> => create database formyuser;
>
> But If this user connects to the database and tries to create a table, he
> has no rights. I must (the super user) create the table for him and then
> give him all the permissions with GRANT.
>
> So my question is : How can I create a database for a simple user (ie not
> super user) and give him all the rigths to create and drop tables in it ?

Create the user with database create permission and then let the user
create the database directly, so they are the default owner for it.

Otherwise, yes, you need to grant all of the permission to the user.

-- Brett
                                     http://www.chapelperilous.net/~bmccoy/
---------------------------------------------------------------------------
Whenever people agree with me, I always think I must be wrong.
- Oscar Wilde


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

Предыдущее
От: Tressens Lionel
Дата:
Сообщение: permissions on databases
Следующее
От: Stephan Szabo
Дата:
Сообщение: Re: ON DELETE CASCADE and TRIGGER