Re: Rights

From: Ralf Schnickmann <ralf_schnickmann_at_gmx.de>
Date: Thu, 28 Aug 2003 10:07:23 +0200
Message-ID: <bikd40$a8bll$1@uni-berlin.de>

So I created this query:

SELECT TABLE_NAME, OWNER, PRIVILEGE
FROM USER_TAB_PRIVS
UNION
SELECT TABLE_NAME, TABLE_SCHEMA, PRIVILEGE FROM USER_ROLE_PRIVS, ALL_TAB_PRIVS
WHERE GRANTED_ROLE = GRANTEE In sql+ or in toad in can start this query correctly and it returns several rows.

But starting this query in my c# application i got no rows returned. The intresting thing is that i can start these two SELECT statements seperatly with the correct result.
Only the union of these statements fails... no errors but no rows returned...

Any ideas?

Geetings,
Ralf

"Daniel Morgan" <damorgan_at_exxesolutions.com> schrieb im Newsbeitrag news:3F4D07F1.2718B2C3_at_exxesolutions.com...
> Ralf Schnickmann wrote:
>
> > Hi!
> >
> > Connected as user x i like to know which rights user x has, related to
all
> > objects in the database and what right is needed to create a user?
> >
> > Greetings, Ralf
>
> USER_SYS_PRIVS
> USER_TAB_PRIVS
> USER_TAB_PRIVS_RECD
> USER_COL_PRIVS
> USER_COL_PRIVS_RECD
> USER_ROLE_PRIVS
>
> --
> Daniel Morgan
> http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
> http://www.outreach.washington.edu/extinfo/certprog/aoa/aoa_main.asp
> damorgan_at_x.washington.edu
> (replace 'x' with a 'u' to reply)
>
>
Received on Thu Aug 28 2003 - 03:07:23 CDT