Received: from email.eximsoft.com (gw.eximsoft.com [164.164.87.130]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id e9UBa6277446 for ; Mon, 30 Oct 2000 06:36:27 -0500 (EST) (envelope-from mercy.prabha@eximsoft.com) Received: from cs870023_navina (unknown [10.10.10.175]) by email.eximsoft.com (Postfix) with SMTP id 33BC7690D0 for ; Mon, 30 Oct 2000 17:00:34 +0530 (IST) Message-ID: <001101c04264$e8e49070$af0a0a0a@cs870023_navina.exim.com.> From: "Mercy" To: Subject: question regarding grant privilege Date: Mon, 30 Oct 2000 17:01:13 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_000E_01C04293.028D6320" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 4.72.3110.5 X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3 X-Archive-Number: 200010/2 X-Sequence-Number: 2 This is a multi-part message in MIME format. ------=_NextPart_000_000E_01C04293.028D6320 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable hi The documents on Postgresql gives explanation on grant privilge that it co= uld be extended to 1. Tables 2. Views 3. Sequences Could the same grant commant be extended to a database.the reason for this = is, if i have 100 tables in a db and i want all the users to be given 'all on' permission i have to do it by giving the grant command= for all 100 tables which would be time consuming. Kindly clarify on this issue regards Mercy ------=_NextPart_000_000E_01C04293.028D6320 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
hi
 
The documents on Postgresql  gives= =20 explanation on grant privilge that it could be extended to
 
1.    Tables
2.    Views
3.    Sequences
 
Could the same grant commant be extended to a database.= the=20 reason for this is, if i have 100 tables in a db and i want all the=20 users
to be given 'all on' permission i have to do it by givi= ng the=20 grant command for all 100 tables which would be time consuming.
Kindly clarify on this issue
 
regards
Mercy
------=_NextPart_000_000E_01C04293.028D6320--