Hudson config for SVN credentials

I've been integrating Hudson into our build process, interesting enough that I couldn't find where to set the subversion credentials from Hudson's config menus.  Found the solution from web, simply go to URL to config:
http://${HUDSON_HOST:PORT}/scm/SubversionSCM/enterCredential 

the file on the server is under:
${HOME}/.hudson/hudson.scm.SubversionSCM.xml

Not sure if it supports multiple repositories with different credentials.

Reference:
http://www.testearly.com/2007/06/12/subversion-authentication-in-hudson/

integrate Subversion with Windows Active Directory

apache httpd.conf

<Location /reponame>

DAV svn

SVNPath /opt/subversion/rep/reponame

AuthzSVNAccessFile /opt/subversion/rep/reponame/conf/authz

Require valid-user

AuthBasicProvider ldap

AuthType Basic

AuthName "subversion repository"

AuthLDAPURL "ldap://hostname:389/OU=Users,OU=Shire,DC=shire,DC=org?sAMAccountName?sub?(objectClass=hobbitName)" NONE

AuthLDAPBindDN "CN=Bilbo,CN=Users,DC=shire,DC=org"

AuthLDAPBindPassword "RiNg"

</Location>

---

authz example

[groups]

wizard = gandalf

hobbit = forodo, sam

[/]

#* = r

@wizard = rw

@hibbot = r

solaris ps wide

ps -awwx doesn't work under solaris?

don't use the one under /usr/bin/

try this:
/usr/ucb/ps -awwx

create read-only user in postgres

grant select,insert,update,delete only allows you to grant privileges to an indiviual table.

the following generate the grant commands to all tables in a database for you to copy & paste:

select 'grant select on ' || relname || ' to username;' from pg_class join pg_namespace on pg_namespace.oid=pg_class.relnamespace where nspname ='public' and relkind in ('r','v');

Reference: http://stackoverflow.com/questions/760210/how-do-you-create-a-read-only-user-in-postgresql