Sams Teach Yourself SQL in 24 Hours, Third Edition By Ronald R. Plew, Ryan K. Stephens
Table of Contents
Hour 21. Working with the System Catalog
Q&A
Q1:
As a database user , I realize I can find information about my objects. How can I find information about other users' objects?
A1:
There is sets of tables and/or views that users can use to query in most system catalogs. One set of these tables and views includes information on what objects to which you have access.
Q2:
If a user forgets his or her password, is there a table that the database administrator can query to get the password?
A2:
Yes and no. The password is maintained in a system table, but is typically encrypted so that even the database administrator cannot read the password. The password will have to be reset if the user forgets it, which the database administrator can easily accomplish.
Q3:
How can I tell what columns are in a system catalog table?
A3:
The system catalog tables can be queried as any other table. Simply query the table that holds that particular information.
