"Della-Croce, Gregory" <Greg_Della-Croce@xxxxxxxxxxxx> writes: > I am new at the Postgres DBA - Admin stuff. So when asked to create a read only profile for our database in Postgres 8.4 I did the following: > * create role RO_User password 'xxxxxxxxxxx' NOSUPERUSER NOCREATEDB NOCREATEROLE INHERIT LOGIN; > * select 'grant select on ' || tablename || ' to \"RO_User\"; 'from pg_tables where schemaname = 'public'; Uh, that only printed the GRANT commands you needed, it didn't execute them. regards, tom lane -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
