Re: where are privileges on database level kept?

Posted in 1994

Scott Ford — Tue, 18 Oct 94 00:06:00 GMT — source: Informix-list mailing list archive (1991-1998)

In article <37makg$bp5@infoserv.rug.ac.be> rvdbergh@egidius.rug.ac.be (Ria Vandenberghe) 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. We query the sysusers table, which has username and usertype columns. The usertype column will have the value of D, R, or C, denoting that the user has "dba", "resource", or "connect" access. -- Scott F. Ford, DBA / Unix SA | sford@wvus.org bps (Benefit Panel Services) | elroy.jpl.nasa.gov!wvus!sford 888 South Figueroa Street, Suite 1400 | Voice: (213) 489-2694 Los Angeles, CA. 90017 | FAX: (213) 489-7973 "...The bozone layer: shielding the rest of the solar system from the earth's harmful effects...."