Re: rights on a databse / server

Posted in 1999

Sujit.Pal@bankofamerica.com — Thu, 18 Nov 1999 10:32:34 -0800 — source: Informix-list mailing list archive (1991-1998)

Andreas Check out the system catalogs sysusers, systabauth (in conjunction with systables), syscolauth (in conjunction with systables and syscolumns), sysprocauth (in conjunction with sysprocedures). Unless you have granted table or column level rights, sysusers is sufficient, snce it gives you which users have what database level privs on the database. We have lot of stored procs here, and we grant some users rights to execute certain procedures, so we need sysprocauth as well. HTH Sujit him_lommel@t-online.de (Andreas Lommel) on 11/18/99 03:49:25 AM Please respond to him_lommel@t-online.de (Andreas Lommel) To: informix-list@iiug.org cc: (bcc: Sujit Pal) Subject: rights on a databse / server Hi, Which is the way to see all rights the users have on my databases. The system: IDS 7.3 on solaris 2.6.