Re: Table privileges

Dirk, Did you grant the privileges originally? I've seen something similiar if you are not the grantor of these privileges. You can either login as the original grantor or use "SET SESSION AUTHORIZATION <grantor>" if you have DBA privileges. Hope this helps! On May 18, 1:50pm, Dirk Moolman wrote: > Subject: Table privileges > Hi, I have not done this before. I am trying to revoke all rights from > public on specific tables and then to grant select rights only, but for > some reason the privileges stay active (are not revoked) on these tables - > > "revoke all on <tabname> from public" > "grant select on <tabname> to public" > > The commands are executed successfully, but when I do a table info in > dbaccess afterwards, "public" still has full table rights - update, insert, > delete, etc. > > I also tried revoking these rights individually - > "revoke update on <tabname> from public" > but this crashes on - > 580: Cannot revoke permission. > 111: ISAM error: no record found.> > How can I get around all this ? >-- End of excerpt from Dirk Moolman -- ********************************************************************** Ray, Alicia K. E-Mail : Alicia.Ray@med.osd.mil EDS-D/SIDDOMS Phone : 703-845-3807 5113 Leesburg Pike FAX : 703-845-3899 Skyline 4 Suite 800 Falls Church, VA 22041-3201 **********************************************************************