This is a multi-part message in MIME format.
------_=_NextPart_001_01CA2711.40C2648E
Content-Type: text/plain;
charset="US-ASCII"
Content-Transfer-Encoding: quoted-printable
Hello,
I would like to have a "view only" admin role with SELECT ONLY rights
on the whole database.
Our largest Database has more than 50'000 tables with a few hundreds
added/deleted per day...
The link in this Post leads to a php error.
http://archives.postgresql.org/pgsql-sql/2006-05/msg00023.ph p
Can someone points me to the script, or is there a better approach to
create such a role ?
Thanks,
Marc Mamin
------_=_NextPart_001_01CA2711.40C2648E
Content-Type: text/html;
charset="US-ASCII"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
6.5.7651.59">
<TITLE>GRANT SELECT ON DATABASE</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<P><FONT SIZE=3D2 FACE=3D"Arial">Hello,</FONT>
</P>
<BR>
<P><FONT SIZE=3D2 FACE=3D"Arial">I would like to have a "view =
only" admin role with SELECT ONLY rights on the whole =
database.</FONT>
</P>
<P><FONT SIZE=3D2 FACE=3D"Arial">Our largest Database has more than =
50'000 tables with a few hundreds added/deleted per day...</FONT>
</P>
<P><FONT SIZE=3D2 FACE=3D"Arial">The link in this Post leads to a php =
error.</FONT>
<BR><A =
HREF=3D"http://archives.postgresql.org/pgsql-sql/2006-05/msg 00023.php"><U=
><FONT COLOR=3D"#0000FF" SIZE=3D2 =
FACE=3D"Arial">http://archives.postgresql.org/pgsql-sql/2006 -05/msg00023.=
php</FONT></U></A>
</P>
<P><FONT SIZE=3D2 FACE=3D"Arial">Can someone points me to the script, or =
is there a better approach to create such a role ?</FONT>
</P>
<BR>
<P><FONT SIZE=3D2 FACE=3D"Arial">Thanks,</FONT>
</P>
<P><FONT SIZE=3D2 FACE=3D"Arial">Marc Mamin</FONT>
</P>
</BODY>
</HTML>
------_=_NextPart_001_01CA2711.40C2648E--
