Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    Aleph

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Aleph
    3. Knowledge Articles
    4. CREATE SESSION privilege lacks

    CREATE SESSION privilege lacks

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    No headers

     

    • Product: Aleph
    • Product Version: 20, 21, 22, 23
    • Relevant for Installation Type: Dedicated-Direct, Direct, Local, Total Care

     

    Problem Symptoms:
    Connecting using library name to Oracle using SqlPlus (s+ xxxyy) it displays this error message:
    ERROR:
    ORA-01045: user xxxyy lacks CREATE SESSION privilege; logon denied

     

    Cause:
    The ALEPH_LIBRARY role was not created.

     

    Resolution:
    Created using the /exlibris/app/oracle/admin/aleph20/scripts/create_role_profile script, and after granted this role to the Oracle users with 

    SQL>  grant aleph_library to xxxyy;

    from aleph_dba user

     

     


    • Article last edited: 17-Jun-2016
    View article in the Exlibris Knowledge Center
    1. Back to top
      • create_rts: "Cannot find or open library file: -l java"; AIX
      • CREATE SYNONYM error: name is already used by an existing object
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      This page has no tags.
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved