Re: Script to show all user privileges in a db

From: Massa Batheli <>
Date: Wed, 26 Dec 2007 08:20:55 -0800 (PST)
Message-ID: <>

Your input is greatly appreciated
Querying the dictionary tables is not the issue here Where I will need help is putting it together.

username: Massa

Roles: connect resouce

Privileges: select any table

Table Priliges:
select on
delete on
insert into

Username Batheli

roles: resource create session

privs: select any dictionary

table privileges:
select * from
insert into

Thanks a lot for your time guys
And may the new year be a great one

Massa Received on Wed Dec 26 2007 - 10:20:55 CST

Original text of this message