I am automating the db initialization; I have a script that reads Shema file and output it again withe the create user section with the passwords. I also have another script that will pick up the output.sql file and initialize it against the DB. using a master password. what I am about to do now is to not to have my script open the schema file and initialize without the section below, maybe my script is messing it up the schema when writes it out.
----- Create none root user ------- CREATE USER xxxx WITH PASSWORD 'xxxxxx'; GRANT ALL PRIVILEGES ON DATABASE "xxxxx" to db_uidname; GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA public TO xxxx; GRANT usage, select on all sequences in schema public to xxxx; -- Sent from: http://apache-guacamole-general-user-mailing-list.2363388.n4.nabble.com/ --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
