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.