Re: grant a db
От | Dan Wilson |
---|---|
Тема | Re: grant a db |
Дата | |
Msg-id | 008901c06a2b$ff95a8b0$078353d8@danwilson обсуждение исходный текст |
Ответ на | RE: grant a db ("Nick Fankhauser" <nickf@ontko.com>) |
Список | pgsql-general |
Just recently added this functionality to phpPgAdmin. You can now update the ACL of all the objects (tables, sequences, views) of a database at the same time. This will be part of the next release (2.2.1) which should happen this week sometime. Look for the announcement. -Dan ----- Original Message ----- From: "Nick Fankhauser" <nickf@ontko.com> To: "Martin A. Marques" <martin@math.unl.edu.ar> Cc: "pgsql-general" <pgsql-general@postgresql.org> Sent: Tuesday, December 19, 2000 5:29 AM Subject: RE: [GENERAL] grant a db > I believe it has to be each table- Oracle has a nice "all tables" option > which might be worth the developer's consideration on the next round. I need > to do this regularly, so I'll probably see if I can write a tool to create a > SQL script. I'll let you know when I get it done. > > -Nick > > --------------------------------------------------------------------- > Nick Fankhauser > > Business: > nickf@ontko.com Phone 1.765.935.4283 Fax 1.765.962.9788 > Ray Ontko & Co. Software Consulting Services http://www.ontko.com/ > > Personal: > nickf@fankhausers.com http://www.fankhausers.com > > > > > > -----Original Message----- > > From: pgsql-general-owner@postgresql.org > > [mailto:pgsql-general-owner@postgresql.org]On Behalf Of Martin A. > > Marques > > Sent: Tuesday, December 19, 2000 8:20 AM > > To: pgsql-general@postgresql.org > > Subject: [GENERAL] grant a db > > > > > > Maybe I'm confused, but can I GRANT a user with ALL privileges on > > a database, > > or does it have to do it on each table? > > > > -- > > System Administration: It's a dirty job, > > but someone told I had to do it. > > ----------------------------------------------------------------- > > Martín Marqués email: martin@math.unl.edu.ar > > Santa Fe - Argentina http://math.unl.edu.ar/~martin/ > > Administrador de sistemas en math.unl.edu.ar > > ----------------------------------------------------------------- > >
В списке pgsql-general по дате отправления: