Sams Teach Yourself SQL in 24 Hours, Second Edition

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 are 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 ...