74068

How do i create a user without password in oracle 10g?

I am trying to create a user without any password by using queries-

create user abc; create user 'abc'@'localhost';

but neither of them works. It is given on oracle docs that it is valid to create user with no password by including no IDENTIFIED BY clause.

Please help me with this query.

Answer1:

Either use:

    <li>Oracle wallet. User is identified via password, but the password is not prompted manually.</li> <li>External authentication. CREATE USER XY IDENTIFIED EXTERNALLY; The user XY must then have OS account on the DB server.</li> </ul>

    Answer2:

    you can create user without password by using externally keyword OS authentication of that user is used as password,user should have access permission on database .

Recommend

  • Global Variables vs. Local Variables
  • How to get message from GCM message body in android?
  • Detox, multiple elements were matched for button in transition
  • Transaction ID for google play to transfer app to another account
  • Android studio 3.1 rebuild project each time to see the changes
  • Socket.io on socket disconnect
  • Hakyll says “Dependency cycle detected: …”
  • command line of process by name
  • SQL Server re-calculate or not?
  • Does the MySQL IN clause execute the subquery multiple times?
  • Which open source license has no forking [closed]
  • Do query loads all the data in memory
  • Javascript, Regex - I need to grab each section of a string contained in brackets
  • Tomcat memory Leak
  • Suppressing passwd when calling sqlplus from shell script
  • PLSQL: Get number of records updated vs inserted when a merge statement is used
  • Authentication in Play! and RestEasy
  • Zurb Foundation _global.scss meta styles for js?
  • Unable to decode certificate at client new X509Certificate2()
  • How to run “Deployd” on port 80 instead of port 5000 in webserver.
  • Can you perform a UNION without a subquery in SQLAlchemy?
  • MongoError: Incorrect arguments
  • Django rest serializer Breaks when data exists
  • PostgreSQL Query without WHERE only ORDER BY and LIMIT doesn't use index
  • jQuery .attr() and value
  • Azure Cloud Service Web Role web pages do not load
  • Apache 2.4 and php-fpm does not trigger apache http basic auth for php pages
  • In LanguageTool, how do you create a dictionary and use it for spell checking?
  • Display Images one by one with next and previous functionality
  • Release, debug version and Authorization Google?
  • QuartzCore.framework for Mono Develop
  • RestKit - RKRequestDelegate does not exist
  • Is there a mandatory requirement to switch app.yaml?
  • Revoking OAuth Access Token Results in 404 Not Found
  • SQL merge duplicate rows and join values that are different
  • Authorize attributes not working in MVC 4
  • Busy indicator not showing up in wpf window [duplicate]
  • UserPrincipal.Current returns apppool on IIS
  • Python/Django TangoWithDjango Models and Databases
  • Net Present Value in Excel for Grouped Recurring CF