Re: [ADMIN] Permissions not removed when group dropped

2005-05-14 Thread Tom Lane
Alvaro Herrera <[EMAIL PROTECTED]> writes: > No, that's why I haven't mentioned it :-) I know I can't do anything > about objects in other databases. But I have wondered if we could > implement CASCADE behavior for an object whose dependencies are only > local to the current database (where CASCA

Re: [ADMIN] Permissions not removed when group dropped

2005-05-13 Thread Alvaro Herrera
On Fri, May 13, 2005 at 10:48:13PM -0400, Tom Lane wrote: > Alvaro Herrera <[EMAIL PROTECTED]> writes: > > We are working on it, and hopefully in 8.1 you will be told where the > > user/group is referenced if you try to drop it. Automatically deleting > > the references from all ACLs has not been

Re: [ADMIN] Permissions not removed when group dropped

2005-05-13 Thread Tom Lane
Alvaro Herrera <[EMAIL PROTECTED]> writes: > We are working on it, and hopefully in 8.1 you will be told where the > user/group is referenced if you try to drop it. Automatically deleting > the references from all ACLs has not been discussed but it's a possible > outcome of the implementation. [

Re: [ADMIN] Permissions not removed when group dropped

2005-05-13 Thread Alvaro Herrera
On Fri, May 13, 2005 at 03:43:54PM -0500, Harris, Richard wrote: Hi, > I'm using PostgreSQL 8.0. I created a group called grpA and granted grpA > 'SELECT' permission on view viewA. When I dropped grpA and created group > grpB, group grpB 'automatically' has SELECT permission to viewA. After > dro

[ADMIN] Permissions not removed when group dropped

2005-05-13 Thread Harris, Richard
Hi, I'm using PostgreSQL 8.0. I created a group called grpA and granted grpA 'SELECT' permission on view viewA. When I dropped grpA and created group grpB, group grpB 'automatically' has SELECT permission to viewA. After dropping a group with permission to a view, I see that the permission stored