Please provide sql script for following

You were just hired as a new junior Oracle database administrator (DBA) to assist a team of five senior database administrators. In your first week, a new employee (Mr. John Smith) hired by the IT department, you were handed the task of creating DB accesses for this employee.

1. Please write a script for creating database accounts for John on Oracle Server. And at the end of the creation, list the user information that shows a successful creation of the user account.
2. Please write a script or give screenshots for creating DB account for John on MS SQL Server. And at the end of the creation, list the user information that shows a successful creation of the user account.
• 
  
  • 
    
    • 
      

Answer rating: 100% (QA)

a i binbash Create database account for John Check if the user already exists if id u john devnull 2... View the full answer