Re: Script to show all user privileges in a db
From: Massa Batheli <mngong_at_gmail.com>
Date: Wed, 26 Dec 2007 08:20:55 -0800 (PST)
Message-ID: <f4e91b43-4424-44b0-b51f-0b06f51415e8@i3g2000hsf.googlegroups.com>
Date: Wed, 26 Dec 2007 08:20:55 -0800 (PST)
Message-ID: <f4e91b43-4424-44b0-b51f-0b06f51415e8@i3g2000hsf.googlegroups.com>
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 adp.tax
delete on adp.tax
insert into adp.tax
Username Batheli
roles: resource create session
privs: select any dictionary
table privileges:
select * from adp.tax
insert into adp.tax
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