This is a multi-part message in MIME format.
------_=_NextPart_001_01C8E0B0.AD9B2CC7
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
This email is subject to a disclaimer which may be found by connecting to=
=20www.medscheme.co.za and clicking on the "Terms of Use" link.
Alternatively, the disclaimer can be emailed to you by sending a blank em=
ail to "meds_disclaimer@[EMAIL PROTECTED]
".
=A0
-------------------------------------------------------------------------=
--------------------------------------------------------
Hi
=20
I was wondering if there are similar views in postgres to those in
Oracle (DBA_TAB_PRIVS, DBA_ROLE_PRIVS etc.) where one can obtain current
privileges granted to objects on the database. I have come across the
\dp and \z commands but I want to write dynamic sql to generate scripts
for granting and revoking. Any help would be appreciated.
=20
Regards
Marc
------_=_NextPart_001_01C8E0B0.AD9B2CC7
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<html xmlns:v=3D"urn:schemas-microsoft-com:vml" xmlns:o=3D"urn:schemas-mi=
crosoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:wo=
rd" xmlns:x=3D"urn:schemas-microsoft-com:office:excel" xmlns:p=3D"urn:sch=
emas-microsoft-com:office:powerpoint" xmlns:a=3D"urn:schemas-microsoft-co=
m:office:access" xmlns:dt=3D"uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" x=
mlns:s=3D"uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:rs=3D"urn:sche=
mas-microsoft-com:rowset" xmlns:z=3D"#RowsetSchema" xmlns:b=3D"urn:schema=
s-microsoft-com:office:publisher" xmlns:ss=3D"urn:schemas-microsoft-com:o=
ffice:spreadsheet" xmlns:c=3D"urn:schemas-microsoft-com:office:component:=
spreadsheet" xmlns:oa=3D"urn:schemas-microsoft-com:office:activation" xml=
ns:html=3D"http://www.w3.org/TR/REC-html40"
xmlns:q=3D"http://schemas.xml=
soap.org/soap/envelope/" xmlns:D=3D"DAV:" xmlns:x2=3D"http://schemas.micr=
osoft.com/office/excel/2003/xml" xmlns:ois=3D"http://schemas.microsoft.co=
m/sharepoint/soap/ois/" xmlns:dir=3D"http://schemas.microsoft.com/sharepo=
int/soap/directory/" xmlns:ds=3D"http://www.w3.org/2000/09/xmldsig#"
xmln=
s:dsp=3D"http://schemas.microsoft.com/sharepoint/dsp"
xmlns:udc=3D"http:/=
/schemas.microsoft.com/data/udc" xmlns:xsd=3D"http://www.w3.org/2001/XMLS=
chema" xmlns:sub=3D"http://schemas.microsoft.com/sharepoint/soap/2002/1/a=
lerts/" xmlns:ec=3D"http://www.w3.org/2001/04/xmlenc#"
xmlns:sp=3D"http:/=
/schemas.microsoft.com/sharepoint/" xmlns:sps=3D"http://schemas.microsoft=
..com/sharepoint/soap/"
xmlns:xsi=3D"http://www.w3.org/2001/XMLSchema-inst=
ance" xmlns:udcxf=3D"http://schemas.microsoft.com/data/udc/xmlfile"
xmlns=
:wf=3D"http://schemas.microsoft.com/sharepoint/soap/workflow/"
xmlns:mver=
=3D"http://schemas.openxmlformats.org/markup-compatibility/2006"
xmlns:m=3D=
"http://schemas.microsoft.com/office/2004/12/omml"
xmlns:mrels=3D"http://=
schemas.openxmlformats.org/package/2006/relation****ps" xmlns:ex12t=3D"htt=
p://schemas.microsoft.com/exchange/services/2006/types" xmlns:ex12m=3D"ht=
tp://schemas.microsoft.com/exchange/services/2006/messages" xmlns:Z=3D"ur=
n:schemas-microsoft-com:" xmlns=3D"http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=3DContent-Type content=3D"text/html; charset=3Dus-ascii"=
>
<meta name=3DGenerator content=3D"Microsoft Word 12 (filtered medium)">
<style>
<!--
=20/* Font Definitions */
=20@[EMAIL PROTECTED]
15 5 2 2 2 4 3 2 4;}
=20/* Style Definitions */
=20p.MsoNormal, li.MsoNormal, div.MsoNormal
=09{margin:0in;
=09margin-bottom:.0001pt;
=09font-size:11.0pt;
=09font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
=09{mso-style-priority:99;
=09color:blue;
=09text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
=09{mso-style-priority:99;
=09color:purple;
=09text-decoration:underline;}
span.EmailStyle17
=09{mso-style-type:personal-compose;
=09font-family:"Calibri","sans-serif";
=09color:windowtext;}
..MsoChpDefault
=09{mso-style-type:ex****t-only;}
@[EMAIL PROTECTED]
Section1
=09{size:8.5in 11.0in;
=09margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
=09{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
=20<o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
=20<o:shapelayout v:ext=3D"edit">
=20 <o:idmap v:ext=3D"edit" data=3D"1" />
=20</o:shapelayout></xml><![endif]-->
</head>
<body lang=3DEN-US link=3Dblue vlink=3Dpurple>
<P><FONT size=3D1><SPAN=20
style=3D"FONT-SIZE: 7.5pt; COLOR: gray; FONT-FAMILY: Arial"><FONT size=3D=
1>This=20
email is subject to a disclaimer</FONT> which may be found on our website=
=20by=20
clicking on this link</SPAN><FONT face=3DArial color=3D#999999><SPAN=20
style=3D"FONT-SIZE: 7.5pt; COLOR: #999999; FONT-FAMILY: Arial">:</SPAN></=
FONT><FONT=20
face=3DArial><SPAN style=3D"FONT-SIZE: 7.5pt; FONT-FAMILY: Arial"> <A=20
title=3Dhttp://www.medscheme.co.za/=20
href=3D"https://www.medscheme.co.za/EX_Medscheme_VS07/Do***ents/PDF/Medsc=
heme%20Limited%20Terms%20of%20Use.pdf">disclaimer.</A>=20
<FONT color=3Dgray><SPAN style=3D"COLOR: gray">If you would prefer, the d=
isclaimer=20
can be emailed to you by clicking</SPAN></FONT> <A=20
title=3Dmailto:Meds_disclaimer@[EMAIL PROTECTED]
"mailto:Meds_disclaimer@[EMAIL PROTECTED]
">here</A>.</SPAN></FONT></=
FONT>=20
</P>
<P> </P>
<P> </P>
<div class=3DSection1>
<p class=3DMsoNormal>Hi<o:p></o:p></p>
<p class=3DMsoNormal><o:p> </o:p></p>
<p class=3DMsoNormal>I was wondering if there are similar views in postgr=
es to
those in Oracle (DBA_TAB_PRIVS, DBA_ROLE_PRIVS etc.) where one can obtain=
current privileges granted to objects on the database. I have come across=
=20the
\dp and \z commands but I want to write dynamic sql to generate scripts f=
or
granting and revoking. Any help would be appreciated.<o:p></o:p></p>
<p class=3DMsoNormal><o:p> </o:p></p>
<p class=3DMsoNormal>Regards<o:p></o:p></p>
<p class=3DMsoNormal>Marc<o:p></o:p></p>
</div>
</body>
</html>
------_=_NextPart_001_01C8E0B0.AD9B2CC7--
|
