Re: system catalogs

In article <41ba3p$9et@dub-news-svc-4.compuserve.com>, <102076.2137@compuserve.com> wrote: > > trvsryhn@dordt.edu (Travis Rayhons) writes: >> 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. >>What I want to do is revoke all priviledges from everyone and >>then grant only those permissions that are needed. This is the >>next stage in implementation and I just want to make sure that I >>can't mess anything up. >> Hi Travis, you should better use the sql-commands GRANT and REVOKE instead of directly manipulating the systables. These commands will do everything for you. Hope that helps... Dirch +----------------------------------------------------------------+ | Stadt Muelheim an der Ruhr | email scheer@stadt-mh.de | | Dirk Scheer / Amt 10-3 | telefon +49 208 455 1006 | | Ruhrstr. 32 | fax +49 208 455 1099 | | D-45468 Muelheim an der Ruhr | | +----------------------------------------------------------------+