Re: Modifying system tables

Just be very careful and make sure that your where clause in your Permission program has 'and tabid > 100' in it. Travis Rayhons (trvsryhn@dordt.edu) wrote: : I am developing a database of all the permissions of my users to : each database that they use. This way I can determine what : permissions that each user has and keep access to certain databases : very secure by revoking everyone else. : I was wondering what harm or side effects could be had if I : directly modify the tables: sysusers, systabauth, syscolauth. -- ---------------------------------------------------------------------------- Neil @ Storm. Any ideas expressed above are the feelings of my employer. I own the company. ----------------------------------------------------------------------------