20 lines
740 B
Plaintext
20 lines
740 B
Plaintext
|
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>
|