Re: [GENERAL] Re: grant privileges to a database

2001-01-31 Thread GH
On Wed, Jan 31, 2001 at 03:39:46PM -0700, some SMTP stream spewed forth: > : El Mié 31 Ene 2001 18:32, Dan Wilson escribió: > : > You can do this in phpPgAdmin... it's a hack because it just pulls in > all > : > the objects/relations and runs a single grant statement on them, but it > : > works.

Re: [GENERAL] Re: grant privileges to a database

2001-01-31 Thread Dan Wilson
You can do this in phpPgAdmin... it's a hack because it just pulls in all the objects/relations and runs a single grant statement on them, but it works. It puts together a query like the following: GRANT ALL ON table1, table2, table3, view1, view2, sequence1, sequence2 TO user Which I suppose y

Re: [GENERAL] Re: grant privileges to a database

2001-01-31 Thread Dan Wilson
: El Mié 31 Ene 2001 18:32, Dan Wilson escribió: : > You can do this in phpPgAdmin... it's a hack because it just pulls in all : > the objects/relations and runs a single grant statement on them, but it : > works. It puts together a query like the following: : > : > GRANT ALL ON table1, table2, t

[GENERAL] Re: Re: grant privileges to a database [URGENT]

2001-01-31 Thread Mike Miller
MySQL has this feature. I run a multi-user system and require shared MySQL And PostgreSQL dbs. I have mysql fine. Users have their DBs and can only access their DBs... but theres no real way to do this in Postgres. I can restrict tables, but I can still create tables in other poeples DBs.

Re: [GENERAL] Re: grant privileges to a database

2001-01-31 Thread Martin A. Marques
El Mié 31 Ene 2001 18:32, Dan Wilson escribió: > You can do this in phpPgAdmin... it's a hack because it just pulls in all > the objects/relations and runs a single grant statement on them, but it > works. It puts together a query like the following: > > GRANT ALL ON table1, table2, table3, view1

[HACKERS] SF company wants to hire pgsql hacker

2001-01-31 Thread Bruce Momjian
A San Francisco company wants to hire a PostgreSQL developer to work on improving the database, and to do some work for the company. I am here at LinuxWorld right now with the CIO of the company. The candidate should be based in North America for Visa reasons, and should be willing to relocat

Re: [GENERAL] Re: grant privileges to a database

2001-01-31 Thread Martin A. Marques
El Mié 31 Ene 2001 15:53, Michael Fork escribió: > This is the closest thing to what you want: > > GRANT ALL ON table TO user; > > (see http://www.postgresql.org/users-lounge/docs/7.0/user/sql-grant.htm) Yes, I'm aware of that. That's why I'm asking for an opinion of the developers on this issue

[HACKERS] Re: [GENERAL] Re: grant privileges to a database

2001-01-31 Thread Michael Fork
This is the closest thing to what you want: GRANT ALL ON table TO user; (see http://www.postgresql.org/users-lounge/docs/7.0/user/sql-grant.htm) Michael Fork - CCNA - MCP - A+ Network Support - Toledo Internet Access - Toledo Ohio On Wed, 31 Jan 2001, Martin A. Marques wrote: > El Mar 30 Ene

[GENERAL] Re: grant privileges to a database

2001-01-31 Thread Martin A. Marques
El Mar 30 Ene 2001 10:08, Martin A. Marques escribió: > Is there a way to grant a user with all privileges on a database? Something > like Informixs GRANT dba? OK, I see that no one responded (except one person how made a personal responce), so I'll add a bit to it. I seem to be aware that Postg

Re: AW: AW: [HACKERS] Like vs '=' bug with indexing

2001-01-31 Thread m w
--- Zeugswetter Andreas SB <[EMAIL PROTECTED]> wrote: > > > > > I am reposting this because I'm not sure it > actually > > > > made it to the list. > > > > > > It did make it to the list, but can you give > more > > > details whether or which of the > > > following you use: > > > --enable-loc

AW: AW: [HACKERS] Like vs '=' bug with indexing

2001-01-31 Thread Zeugswetter Andreas SB
> > > I am reposting this because I'm not sure it actually > > > made it to the list. > > > > It did make it to the list, but can you give more > > details whether or which of the > > following you use: > > --enable-locale ? > > --enable-multibyte ? > > LANG=? > > LC_COLLATE=? >

RE: [HACKERS] 7.1 question

2001-01-31 Thread Magnus Hagander
Yes. You applied my patch for it on the 27th. //Magnus > -Original Message- > From: Bruce Momjian [mailto:[EMAIL PROTECTED]] > Sent: den 25 januari 2001 04:33 > To: Magnus Hagander > Cc: 'Tom Lane'; Zeugswetter Andreas SB; '[EMAIL PROTECTED]' > Subject: [HACKERS] 7.1 question > > > >

AW: [HACKERS] Like vs '=' bug with indexing

2001-01-31 Thread Zeugswetter Andreas SB
> I am reposting this because I'm not sure it actually > made it to the list. It did make it to the list, but can you give more details whether or which of the following you use: --enable-locale ? --enable-multibyte ? LANG=? LC_COLLATE=? > I have a function to t