Skip site navigation (1) Skip section navigation (2)

BUG #4537: role

From: "Marco Peixoto" <mpeixoto(at)metrosp(dot)com(dot)br>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #4537: role
Date: 2008-11-17 21:03:22
Message-ID: 200811172103.mAHL3MI4006562@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      4537
Logged by:          Marco Peixoto
Email address:      mpeixoto(at)metrosp(dot)com(dot)br
PostgreSQL version: 8.2.11
Operating system:   debian 4.1
Description:        role
Details: 

CREATE SCHEMA agd
  AUTHORIZATION postgres;
GRANT ALL ON SCHEMA agd TO postgres;
GRANT USAGE ON SCHEMA agd TO agd_select; (group)

CREATE ROLE r227602 LOGIN
  ENCRYPTED PASSWORD 'md5a4d27e81e0dc6b9828cf2dc84565fb59'
  NOSUPERUSER NOINHERIT NOCREATEDB NOCREATEROLE;
GRANT agd_select TO r227602;

CREATE TABLE agd.clanalis
(
  nr_analista numeric(10) NOT NULL DEFAULT
nextval('agd.clanalis_nr_analista_seq'::regclass), -- Analista
  funcionario integer NOT NULL, -- Funcionário
  CONSTRAINT pk_clanalis PRIMARY KEY (nr_analista),
  CONSTRAINT fk_clanalis_funcionario FOREIGN KEY (funcionario)
      REFERENCES ahb.funcionario (funcionario) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE NO ACTION
)
WITH (OIDS=FALSE);
ALTER TABLE agd.clanalis OWNER TO postgres;
GRANT ALL ON TABLE agd.clanalis TO postgres;
GRANT SELECT ON TABLE agd.clanalis TO agd_select;


[postgres(at)sd5metro1 dados]$ psql -p 5433 tscorp01 -U r227602 -W
Password for user r227602:
Welcome to psql 8.2.11, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help with psql commands
       \g or terminate with semicolon to execute query
       \q to quit

tscorp01=> select * from agd.claloclg;
ERROR:  permission denied for relation clanalis

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2008-11-18 00:30:57
Subject: Re: BUG #4537: role
Previous:From: Alvaro HerreraDate: 2008-11-17 19:56:21
Subject: Re: BUG #4536: raise doesn't add end of line

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group