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.
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
: 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
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.
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
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
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
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
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
--- 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
> > > 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=?
>
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
>
>
>
>
> 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
13 matches
Mail list logo