Re: [PATCHES] Checking for USAGE on SET search_path...

2004-04-08 Thread Tom Lane
Sean Chittenden <[EMAIL PROTECTED]> writes: > This patch does two things: > 1) Changes the semantics of assign_search_path()/'SET search_path' so > that you can't set your search path to a schema you don't have USAGE > privs for. Why is that needed? It's already a no-op AFAIR. It also is inco

[PATCHES] Checking for USAGE on SET search_path...

2004-04-08 Thread Sean Chittenden
This patch does two things: 1) Changes the semantics of assign_search_path()/'SET search_path' so that you can't set your search path to a schema you don't have USAGE privs for. 2) Changes psql's \dn query and its schema tab completion query to incorporate ACL checking so that \dn only lists s