Обсуждение: user delete problem

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

Tomasz Misterka writes:

> 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?

Recreate a user with the same id and clean up the permissions.

--
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter

Hi,

When I gave any user password longer than eight digits, the user can enter
the base with only first eight digits of the password.

Is there any possibility to have longer password?

Tomasz Misterka

On Thu, May 31, 2001 at 12:01:22AM +0200, Tomasz Misterka wrote:
> Hi,
>
> When I gave any user password longer than eight digits, the user can enter
> the base with only first eight digits of the password.
>
> Is there any possibility to have longer password?

It looks like it uses the standard unix crypt() function, which is
traditionally limited to 8 characters.

The file doc/TODO lists a future enhancement to support md5 hashes (and
longer passwords).  Perhaps you could contribute some code to that end?

mrc
--
     Mike Castle      dalgoda@ix.netcom.com      www.netcom.com/~dalgoda/
    We are all of us living in the shadow of Manhattan.  -- Watchmen
fatal ("You are in a maze of twisty compiler features, all different"); -- gcc