> see) Is there an easier way to grant access to all > tables, then just > revoke access to that table? I had to write a > program that > > granted all privileges for (tablename) to > (userlist) > > one line for each tablename. Is there an easier > way... we have 70 tables > in the database.
Just write a program that declares a cursor on the SYS_TABLES table and loops through, issuing a GRANT command to each table it finds (restrict the WHERE clause in the cursor to find only user tables). -- Larry __________________________________ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com
