Re: [SQL] Schema's, roles and privileges

2009-11-30 Thread Harald Fuchs
In article <200911300708.12397.akla...@comcast.net>, Adrian Klaver writes: > From a quick look it would seem the easiest solution would be to change the > search_path in: > citext.sql.in > uuid-ossp.sql.in > These files are found in the respective contrib directories. Uninstall the > modules.

Re: [SQL] Schema's, roles and privileges

2009-11-30 Thread Michael Gould
Thanks Mike Gould "Adrian Klaver" wrote: > On Monday 30 November 2009 6:50:27 am Michael Gould wrote: >> I have a database with a schema called ISS. This is where all of our >> application definitions are stored. We did add 2 contribute modules >> (citext) and guid generator and both of these by

Re: [SQL] Schema's, roles and privileges

2009-11-30 Thread Adrian Klaver
On Monday 30 November 2009 6:50:27 am Michael Gould wrote: > I have a database with a schema called ISS. This is where all of our > application definitions are stored. We did add 2 contribute modules > (citext) and guid generator and both of these by default went to the public > schema. It is our i

[SQL] Schema's, roles and privileges

2009-11-30 Thread Michael Gould
I have a database with a schema called ISS. This is where all of our application definitions are stored. We did add 2 contribute modules (citext) and guid generator and both of these by default went to the public schema. It is our intent to not allow any access to public by our users. A few questi

Re: [SQL] SCHEMA's the easy way?

2004-05-19 Thread Tom Lane
Chris Gamache <[EMAIL PROTECTED]> writes: > I'm planning on dipping my toes into the world of schemata. I have tables, > created in the Public schema, that I'd like to move to the new schema: > Is there an easier, faster, less user-error-prone way around this? pg_dump, edit the "set search_path"

[SQL] SCHEMA's the easy way?

2004-05-19 Thread Chris Gamache
I'm planning on dipping my toes into the world of schemata. I have tables, created in the Public schema, that I'd like to move to the new schema: SELECT * INTO new.tablename FROM public.tablename; CREATE SEQUENCE ...; CREATE INDEX ...; ALTER TABLE ...; BLAH ...; BLAH ...; BLAH ...; DROP public.tab

Re: [SQL] SCHEMA's

2003-03-03 Thread Tom Lane
"Hepworth, Mike" <[EMAIL PROTECTED]> writes: > I want to be able make a user have a default schema other than public. If the schema name is the same as the user name then this happens automatically. Otherwise, you want to set a search_path value for the user --- see ALTER USER and read up on the

[SQL] SCHEMA's

2003-03-03 Thread Hepworth, Mike
Need some help with schema's. I want to be able make a user have a default schema other than public. I want to be able to have several schema's with the same group of tables define in each one. (Example) schema a (users 1,2,3) table a table b table c schema b (users 4,5,6