rights on database

Posted in 2000

Andreas Lommel — Thu, 06 Apr 2000 07:06:40 GMT — source: Informix-list mailing list archive (1991-1998)

Hi there. How mcan I see which users have which rights on a database ? With systables I can only see users.

↪ replying to Andreas Lommel

Art S. Kagel & Family — Fri, 07 Apr 2000 01:43:19 -0400 — source: Informix-list mailing list archive (1991-1998)

Andreas Lommel wrote: > > Hi there. How mcan I see which users have which rights on a database ? > With systables I can only see users. Sysusers contains database and connect level priveleges for users. The table systabauth contains table level privelege information by table, and user. Syscolauth is column level privelege. Sysroles and sysroleauth contain roles and their permission in conjuction with sysusers. There are a few others but you get the idea. -- Art S. Kagel & Family kagel@erols.com