Re: Where are database level privileges kept?

on Mon, 17 Oct 1994 11:29:35 -0400 Ria Writes: >Informix keeps the privileges granted on tables (and columns) in the system >catalog (SYSTABAUTH and SYSCOLAUTH). But where does it keep information >about >the privileges granted on the databases themselves (i.e. information on who >has connect/resource/dba privilege, for each of the databases)? >Are there any utilities which can provide me with this information? > >Many thanks in advance, > >Ria. They are kept in the SYSUSERS table in the USERTYPE column of the selected database. D=DBA R=RESOURCE C=CONNECT ============================================================================ Matt Bentley Medicode, Inc. SLC, UT (801) 536-1124 mbentle@medicode.mhs.compuserve.com ============================================================================