[GENERAL] prevent user change password?

Is it possible to prevent a user from changing their password? I have a database with a 'Guest' account, that will have limited access. I don't want any of my guests to change the Guest account password. tia Richard ---(end of broadcast)--- TIP 2:

Re: [GENERAL] prevent user change password?

On Wed, 01 Jun 2005 11:39:22 -0400, [EMAIL PROTECTED] (Tom Lane) wrote: >> I have a database with a 'Guest' account, that will have limited >> access. I don't want any of my guests to change the Guest account >> password. > >Perhaps you should use something other than password authentication >for

[GENERAL] current_user inside SECURITY DEFINER function?

Is there any way to get the name of the current user inside a PL/pgSQL function that is defined with security definer? current_user gives the name of the user who created the function. The reason I want this is that I intend to use functions to maintain security, like this: userA has only selec

Re: [GENERAL] current_user inside SECURITY DEFINER function?

On Wed, 6 Jul 2005 06:33:58 -0700 (PDT), [EMAIL PROTECTED] (Stephan Szabo) wrote: >SESSION_USER should give the original user. Thanks all, that does what I want. regards Richard ---(end of broadcast)--- TIP 2: you can get off all lists at once w

[GENERAL] Installation on Web Server

I'm wanting to install PHP on a Apache/Linux server with support for PostgreSQL. It seems that I need to install PostgreSQL on the machine first, before the PHP installation will work. The way I've done this previously is simply to install PostgreSQL. However, the database server is in fact anoth

Re: [GENERAL] Installation on Web Server

Thanks for the advise folks. I've just installed postgresql in its entirety, but won't run it. Regards, Richard ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joini