|
- Using Enterprise Manager, create a windows integrated login and set the default database to pubs.
- Print an Oracle report (using SQL) that displays a list of all existing users in the database sorted by the name of the users who were created last month.
- Develop a script that prompt the administrator for an authentication type and then lists all users that are using that entered authentication using SQL.
- Lists all Oracle initialization parameters that are related to authentication.
- A lead developer called the other day to lock an account. Outline the steps that you would take to comply with the request.
- Log on to an Oracle database as SYS and lock the SYS and SYSTEM accounts. Explain what happened.
- List the system (data dictionary) table you would use to view all users in an Oracle database.
- Create a user using Oracle and try to connect to the database. Explain what happened for each user. (You need to create a new account and try to login. You will see why the question was created.)
|
