Table Privileges
IDS 11.70.FC8 Which system table stores these privileges ? User Select Update Insert Delete Index Alter public All All Yes Yes Yes Yes "This email is confidential. If you have received it in error, you are on notice of its status. Please notify us immediately by reply email and then delete this message from your system. Please do not copy it or use it for any purpose, or disclose its contents to any other person as to do so could be a breach of confidentiality. Thank you for your co-operation. "
Hi, Each database has a system catalog table named SYSTABAUTH: http://www-01.ibm.com/support/knowledgecenter/SSGU8G_11.70.0/com.ibm.sqlr.doc/id s_sqr_071.htm Cheers. On Thu, 6 Aug 2015 at 11:43 Dirk Moolma.... <Dirk.Moolman@mtn.co.za> wrote: > IDS 11.70.FC8 > > Which system table stores these privileges ? > > User Select Update Insert Delete Index Alter > > public All All Yes Yes Yes Yes > > "This email is confidential. If you have received it in error, you are on > notice of its status. Please notify us immediately by reply email and then > delete this message from your system. Please do not copy it or use it for > any > purpose, or disclose its contents to any other person as to do so could be > a > breach of confidentiality. Thank you for your co-operation. " > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --089e011771a9262221051ca23cf3
Dirk: If you are not using LBAC privileging: systabauth for full table level privileges, sysfragauth for privileges on individual fragments, and syscolauth for column level privileges. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Thu, Aug 6, 2015 at 6:43 AM, Dirk Moolma.... <Dirk.Moolman@mtn.co.za> wrote: > IDS 11.70.FC8 > > Which system table stores these privileges ? > > User Select Update Insert Delete Index Alter > > public All All Yes Yes Yes Yes > > "This email is confidential. If you have received it in error, you are on > notice of its status. Please notify us immediately by reply email and then > delete this message from your system. Please do not copy it or use it for > any > purpose, or disclose its contents to any other person as to do so could be > a > breach of confidentiality. Thank you for your co-operation. " > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a113ffdbca30b45051ca26495