If an account is locked, a message is displayed and connection as this user is not permitted until the account is unlocked by your DBA. If you log on or connect as a user whose account has expired, you are prompted to change your password before you can connect. Because CONNECT first disconnects you from your current database, you will be left unconnected to any database if you use an invalid username and password in your CONNECT command. In the command-line interface, if you omit the username and password, SQL*Plus prompts you for them. You are prompted to enter the password, FOX. For example, to connect the username TODD to the default database using the password FOX, you could enter CONNECT TODD The username and password must be valid for the database. Once you have logged in, you can connect under a different username using the CONNECT command. Logins are created and displayed in messages during Oracle Database installation.įor further information about the default logins, see the Oracle Database Administrator's Guide. Some of the default login usernames created are: The database administrator (DBA) is responsible for creating your database account with the necessary privileges and giving you the username and password that enables you to access your account.ĭefault logins are created and you are prompted for associated passwords during Oracle Database installation. Your username and password identify you as an authorized user of the Oracle Database schema. When you start SQL*Plus, you need a username and password to login to an Oracle Database schema.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |