psql-admtools

Archived

cli

This repository has been archived on 2024-07-04. You can view files and clone it, but cannot push or open issues or pull requests.

Go to file

oysteini 31db1ad3ae Set encoding to NULL when starting. Submitted by: eirikald		2010-05-11 14:20:10 +00:00
psqldbadm	Set encoding to NULL when starting.	2010-05-11 14:20:10 +00:00
psqluseradm	Riktig host-, bruker- og databasenavn. Ikke riktig passord.	2010-05-11 14:04:59 +00:00
Makefile	Allow things to compile (and hopfully work on Linux)	2010-05-11 13:59:30 +00:00
misc.c	Allow things to compile (and hopfully work on Linux)	2010-05-11 13:59:30 +00:00
README	Initial import	2007-02-13 20:57:45 +00:00
tables.sql	Initial import	2007-02-13 20:57:45 +00:00
TODO	Initial import	2007-02-13 20:57:45 +00:00

README

PSQL-adm tools.

Disallow usage and create as default settings for newly created databases, done
in template1:
	REVOKE USAGE ON SCHEMA public FROM public;
	REVOKE CREATE ON SCHEMA public FROM public;

For every newly created database a schema with the same name as the specified
owner will be created, and the owner will have full authorization over it.

Two databases are used to keep information related to whom owns a user or
database, their structure can be found in tables.sql.

Database information is for now hardcoded into 'psqluseradm/psql.config.h', and
if you change that info you must recompile for them to take effect.

The dbname and dbuser must start with the username of the caller.

 - Eirik Nygaard <eirikald@pvv.ntnu.no>