Sams Teach Yourself SQL in 24 Hours, Third Edition By Ronald R. Plew, Ryan K. Stephens
Table of Contents
Hour 18. Managing Database Users
Q&A
Q1:
Is there a SQL standard for adding users to a database?
A1:
Some commands and concepts are provided by ANSI, although each implementation and each company has its own commands, tools, and rules for creating or adding users to a database.
Q2:
Can user access be temporarily suspended without removing the user ID completely from the database?
A2:
Yes. User access can temporarily be suspended by simply changing the user's password or by revoking privileges that allow the user to connect to the database. The functionality of the user account can be reinstated by changing and issuing the password to the user, or by granting privileges to the user that may have been revoked .
Q3:
Can a user change his or her own password?
A3:
Yes, in most major implementations . Upon user creation or addition to the database, a generic password is usually given to the user and must be changed as quickly as possible by the user to a password of his or her choice. After this has been accomplished, even the database administrator does not know the user's password.
