Thread: user permissions and super user
Hello, I have some databases and pg_hba.conf with this content: ------------ local dialer password dialer host dialer 127.0.0.1 255.255.255.255 password dialer local helltop password helltop host helltop 127.0.0.1 255.255.255.255 password helltop local vote password vote local partnership password partnership host partnership 209.224.53.106 255.255.255.255 password partnership host partnership 127.0.0.1 255.255.255.255 password partnership local webstats password webstats ------------ How can i create user which users password authrization and can access/modify/drop/create all these database. Create languages on databases and so so so. I've try to add line local all password all And in 'all' file i add one user with password, but it doesn't work on other datbases. ------------ With respect, Yuri A. Kabaenkov hellman@artofit.com
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 2001 December 1 04:34 am, Yuri A. Kabaenkov wrote: > How can i create user which users password authrization and can > access/modify/drop/create all these database. > > Create languages on databases and so so so. Sounds like you want a super-user. Try creating a user and giving them the ability to create new users and databases. The file you've been editing specifies which people are allowed to connect to the database system and how they must authenticate themselves. It does not specify privilidges within the database system. That stuff can be controlled by GRANT and REVOKE. - -- Andrew G. Hammond mailto:drew@xyzzy.dhs.org http://xyzzy.dhs.org/~drew/ 56 2A 54 EF 19 C0 3B 43 72 69 5B E3 69 5B A1 1F 613-389-5481 5CD3 62B0 254B DEB1 86E0 8959 093E F70A B457 84B1 "To blow recursion you must first blow recur" -- me -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.6 (GNU/Linux) Comment: For info see http://www.gnupg.org iEYEARECAAYFAjwOK7EACgkQCT73CrRXhLEiUACcDBz6Cgy5JJ0NGV9iYVtDlifL PnMAniQbfDUidAvFcytOSFDSPApYEN+N =9ouJ -----END PGP SIGNATURE-----