On Tue, 2011-12-13 at 10:31 -0500, Rick Dicaire wrote:
> On Tue, Dec 13, 2011 at 2:22 AM, Guillaume Lelarge
> wrote:
> > Did you add the role OID after "WHERE dep.refobjid="? if you didn't,
> > yeah, you'll get a syntax error.
>
> Thanks...tried a few role OIDs for known object ownerships, this c
On Tue, Dec 13, 2011 at 2:22 AM, Guillaume Lelarge
wrote:
> Did you add the role OID after "WHERE dep.refobjid="? if you didn't,
> yeah, you'll get a syntax error.
Thanks...tried a few role OIDs for known object ownerships, this code
returned 0 rows:
select usename,usesysid from pg_user where us
On Mon, 2011-12-12 at 15:40 -0500, Rick Dicaire wrote:
> On Mon, Dec 12, 2011 at 3:21 PM, Guillaume Lelarge
> wrote:
> > On Mon, 2011-12-12 at 14:01 -0500, Rick Dicaire wrote:
> >> Hi folks, I'm generating a dependents report on a db user, I highlight
> >>
> >> I'm trying to see what sql statement
On Mon, Dec 12, 2011 at 3:21 PM, Guillaume Lelarge
wrote:
> On Mon, 2011-12-12 at 14:01 -0500, Rick Dicaire wrote:
>> Hi folks, I'm generating a dependents report on a db user, I highlight
>>
>> I'm trying to see what sql statement is used to generate this report.
>>
>
> It's something like the SQ
On Mon, 2011-12-12 at 14:01 -0500, Rick Dicaire wrote:
> Hi folks, I'm generating a dependents report on a db user, I highlight
> the user as shown in Login Roles, right click -> reports -> Dependents
> Report,
> but I see the "Include the SQL in the report" checkbox greyed out (a
> checkmark shows
Hi folks, I'm generating a dependents report on a db user, I highlight
the user as shown in Login Roles, right click -> reports -> Dependents
Report,
but I see the "Include the SQL in the report" checkbox greyed out (a
checkmark shows in it) in the dialog box.
Resultant report doesn't have the sql
