« Technical Interview & Viva Questions : KyaPoocha.com home page
« Which DB2 catalog tables are used to produce a list of table column by table for all tables in a database ?
Which catalog table stores referential constraints ? »



Which catalog tables contain authorization information ?


The SYSIBM table that contain authorization information are SYSCOLAUTH, SYSDBAUTH, SYSPLANAUTH, SYSTABAUTH and SYSUSERAUTH.



Explore posts in the same categories: Database Interview Questions


BOOKMARK THIS : del.icio.us | Digg it | Furl | reddit |

Related Questions :

  • What is a DB2 catalog ?
    • The DB2 catalog is a set of tables that contain information about all of the DB2 objects(tables, views, plans etc.)....
  • Which DB2 catalog tables are used to produce a list of table column by table for all tables in a database ?
    • The catalog tables to use are the SYSIBM.SYSTABLES and the SYSIBM.SYSCOLUMNS....
  • There are at least seven IDCAMS commands; name and explain each of them ?
    • ALTER modifies information for a catalog, alternate index, cluster or path. BLDINDEX builds the alternate index, of course. ...
  • What is system catalog or catalog relation? How is better known as?
    • A RDBMS maintains a description of all the data that it contains, information about every relation and index that it...
  • What does the RUNSTATS Utility do?
    • The RUNSTATS Utility collects statistical information for DB2 table spaces, partitions, indexes, tables and columns and stores this data in...
  • What is RUNSTATS ?
    • A DB2 utility used to collect statistics about the data values in tables which can be used by the optimizer...
  • What do you mean by authentication and authorization?
    • Authentication is the process of validating a user on the credentials (username and    password) and authorization...
  • Where besides the DB2 catalog is database object information stored by DB2 ?
    • DB2 also stores information about DB2 objects as database descriptors (DBDs) in the DBD Directory table....
  • What is authorization constraint
    • An authorization rule that determines who is permitted to access a Web resource collection....
  • How would one remove old reorg information from the DB2 catalog ?
    • Run the MODIFY RECOVERY Utility....

    Comments are closed.