user delete problem

Поиск
Список
Период
Сортировка
От Tomasz Misterka
Тема user delete problem
Дата
Msg-id Pine.LNX.4.21.0105221005010.1752-100000@www.netla.pl
обсуждение исходный текст
Ответы Re: user delete problem
Список pgsql-admin
Hi,

I've got problem with user.
When I'm delete'ing user from postgreSQL, which has permissions to many
databases, hi leave after himself UID.

the result is:

namebase=# \z
      Access permissions for database "namebase"
 Relation | Access permissions
----------+-------------------------------------------
 dbsx1 | {"=","1118=r","user2=arw","user3=r"}
 dbsx2   | {"=","1118=r","user2=arw","user3=r"}


1118 is a result of deleting user "user1" - this time it's oly read
permission, but how to clean that?

With Regards
Tomasz Misterka


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

Предыдущее
От: Andre Schubert
Дата:
Сообщение: Postgres 7.0.3 Dying
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: cannot connect using terminal nor pgaccess