Re: [GENERAL] grant all privileges to all tables in a database

2005-05-11 Thread Robert Treat
On Thursday 14 April 2005 00:33, Florin Andrei wrote: > On Mon, 2005-04-11 at 03:28 +0200, Daniel Verite wrote: > > Florin Andrei wrote: > > > On MySQL, it's enough to do this: > > > > > > GRANT ALL PRIVILEGES ON dbname.* TO username [IDENTIFIED BY > > > 'password']; > > > > > > On PostgreSQL, you

Re: [GENERAL] grant all privileges to all tables in a database

2005-04-14 Thread Tom Lane
Hugo <[EMAIL PROTECTED]> writes: > is it possible to have nested groups in postgres Not at the moment. There are plans to have 'em for 8.1, though I can't promise for sure that it will get done in time. regards, tom lane ---(end of broadcast)-

Re: [GENERAL] grant all privileges to all tables in a database

2005-04-14 Thread Hugo
is it possible to have nested groups in postgres like in Adaptive server anywhare , I couldn't find anything about it in the help thanks Hugo ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscr

Re: [GENERAL] grant all privileges to all tables in a database

2005-04-13 Thread Florin Andrei
On Mon, 2005-04-11 at 03:28 +0200, Daniel Verite wrote: > Florin Andrei wrote: > > > On MySQL, it's enough to do this: > > > > GRANT ALL PRIVILEGES ON dbname.* TO username [IDENTIFIED BY 'password']; > > > > On PostgreSQL, you have to give it privileges not only to the database, > > but to

Re: [GENERAL] grant all privileges to all tables in a database

2005-04-10 Thread Daniel Verite
Florin Andrei wrote: > On MySQL, it's enough to do this: > > GRANT ALL PRIVILEGES ON dbname.* TO username [IDENTIFIED BY 'password']; > > On PostgreSQL, you have to give it privileges not only to the database, > but to all components within (tables, sequences and whatnot). The > followin

Re: [GENERAL] grant all privileges to all tables in a database

2005-04-10 Thread John DeSoi
On Apr 10, 2005, at 3:10 PM, Florin Andrei wrote: On PostgreSQL, i lost about half a day trying to figure it out. I'm posting this message to help others in my situation. I googled for an answer, but everything that i've found was unhelpful. Hopefully this mailing list is indexed by Google. The lis

[GENERAL] grant all privileges to all tables in a database

2005-04-10 Thread Florin Andrei
I'm a refugee from MySQL due to license restrictions. With MySQL, i was used to do "GRANT ALL PRIVILEGES ON dbname.* TO username" to allow a certain user to do anything within a given database. This is useful when using applications that run on a SQL backend, e.g. a blog or a logging server or some