Re: how to obtain grants for a specific user by reading systables

If you're with version 9, you should download a **free** Windows Gui for all dictionary tables from Quest Software

Now you can create a script like this:

spool my_beautiful_grantor.sql

SQL>select 'grant select on table_name to ' || somegranteecolum from a_system_view;

spool off

You have to set a host of sqlplus parameters off like feeback, etc...

Hope this helps Received on Mon May 15 2006 - 01:39:08 CDT