Bruce Momjian wrote:
Alvaro Herrera wrote:
Hans-Juergen Schoenig wrote:
when thinking of REASSIGNED OWNED people tend to think about tables
rather than about CONNECT rights.
i would suggest to make DROP ROLE just kill the role unless there is a
real object depending on it.
Added to TODO:
Allow dropping of a role that has connection rights
* http://archives.postgresql.org/pgsql-hackers/2008-05/msg00736.php
---
Hans-Juergen Schoenig wrote:
good morning,
some days ago i
Alvaro Herrera wrote:
Hans-Juergen Schoenig wrote:
when thinking of REASSIGNED OWNED people tend to think about tables
rather than about CONNECT rights.
i would suggest to make DROP ROLE just kill the role unless there is a
real object depending on it.
i would not see a permission
Alvaro Herrera wrote:
Hans-Juergen Schoenig wrote:
when thinking of REASSIGNED OWNED people tend to think about tables
rather than about CONNECT rights.
i would suggest to make DROP ROLE just kill the role unless there is a
real object depending on it.
i would not see a permission
good morning,
some days ago i have fallen over an issue which feels more or less like
a bug. consider:
test=# create role xy LOGIN;
CREATE ROLE
test=# grant connect on database test to xy;
GRANT
test=# drop role xy;
ERROR: role xy cannot be dropped because some objects depend on it
Hans-Juergen Schoenig wrote:
test=# create role xy LOGIN;
CREATE ROLE
test=# grant connect on database test to xy;
GRANT
test=# drop role xy;
ERROR: role xy cannot be dropped because some objects depend on it
DETAIL: access to database test
this is a totally fresh instance --- all i
Alvaro Herrera wrote:
Hans-Juergen Schoenig wrote:
test=# create role xy LOGIN;
CREATE ROLE
test=# grant connect on database test to xy;
GRANT
test=# drop role xy;
ERROR: role xy cannot be dropped because some objects depend on it
DETAIL: access to database test
this is a totally fresh
Hans-Juergen Schoenig wrote:
when thinking of REASSIGNED OWNED people tend to think about tables
rather than about CONNECT rights.
i would suggest to make DROP ROLE just kill the role unless there is a
real object depending on it.
i would not see a permission to be an object. what do you