Am 08.06.2012 08:59, schrieb Tom Lane:
"Della-Croce, Gregory" 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 'xxx' NOSUPERUSER NOCREATEDB
NOC
"Della-Croce, Gregory" 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 'xxx' NOSUPERUSER NOCREATEDB
> NOCREATEROLE INHERIT LOGIN;
> *
"Della-Croce, Gregory" 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 'xxx' NOSUPERUSER NOCREATEDB
> NOCREATEROLE INHERIT LOGIN;
>
>
On Fri, 8 Jun 2012 08:29:30 -0400, Della-Croce, Gregory wrote:
The commands worked fine. But when I connected as RO_User and did a
select against a simple table in the DB, I got access denied on the
table.
Check the permissions for that user on the schema public, too.
Jan
--
professional: htt
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 'xxx' NOSUPERUSER NOCREATEDB
NOCREATEROLE INHERIT LOGIN;
* select 'grant select on ' || tablenam
