Rights of users

Posted in 1999

Topics: Security, Permissions & Auditing

HIM Biebesheim — Wed, 10 Feb 1999 17:22:05 +0100 — source: Informix-list mailing list archive (1991-1998)

Hi Where can I get information about granting rights for users. Where can I get information which users have which rights on a db. How can I grant rights on a table or db ? Thanks

↪ replying to HIM Biebesheim

Art S. Kagel — Wed, 10 Feb 1999 12:48:05 -0500 — source: Informix-list mailing list archive (1991-1998)

HIM Biebesheim wrote: > > Hi > Where can I get information about granting rights for users. From TFM. Try the Guide to SQL: Reference. > Where can I get > information which users have which rights on a db. Database level permissions are stored in the table sysusers in each database. The usertype value is 'D'BA, 'R'esource, 'C'onnect. Table level priveledges are stored in systabauth by tabid see the manual to interpret the permission string. Column level permissions are stored in syscolauth, again the interpretation is found in TFM. > How can I grant rights on a table or db ? Informix supports Roles, database, table and column level privileges. > Thanks You're welcome. Art S. Kagel

↪ replying to HIM Biebesheim

f_testa@yahoo.com — Wed, 10 Feb 1999 19:49:52 GMT — source: Informix-list mailing list archive (1991-1998)

Look up the GRANT command from the Informix Guide to SQL manual. By doing a dbschema dump of a database you can view the output to determine what rights are granted to each user, database, and tables. dbschema -d <dbname> -ss <output file> Frank Testa In article <79sbi6$crs$1@news05.btx.dtag.de>, HIM_BIEBESHEIM@t-online.de (HIM Biebesheim) wrote: > Hi > Where can I get information about granting rights for users. Where can I get > information which users have which rights on a db. > How can I grant rights on a table or db ? > Thanks > > -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own