Q&A
| Q1: | If a user forgets his or her password, what should the user do to gain access to the database again? |
| A1: | The user should go to his or her immediate management or an available help desk. A help desk should be able to reset a user's password. If not, the DBA or security officer can reset the password. The user should change the password to a password of his or her choosing as soon as the password is reset and the user is notified. |
| Q2: | What could I do if I wanted to grant CONNECT to a user, but the user does not need all the privileges that are assigned to the connect role? |
| A2: | You would simply not grant CONNECT, but only the privileges required. Should you ever grant CONNECT and the user no longer needs all the privileges that go with it, ... |
Get Sams Teach Yourself SQL in 24 Hours, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
