Results 1 to 5 of 5
  1. #1
    Join Date
    Jun 2013
    Posts
    14

    Unanswered: db2 schema password

    Hi all, I used a admin user to create a schema using :

    create schema abcd authorization abcd


    and now I want to use the schema to create tables and I don't know the password.

    Please help!.

    md

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    In DB2 schema names have no relation to users, so there's no password. You can simply login as the same admin user as before and issue CREATE TABLE ABCD.TABLE1 etc. Alternatively, create a user ABCD in the operating system, grant appropriate permissions to it, then connect to the database using the operating system credentials.
    ---
    "It does not work" is not a valid problem statement.

  3. #3
    Join Date
    Jun 2012
    Posts
    25
    Hi this is Narasimha A, I have doubt, reorg is possible or not, if backup is running.if possible
    how ?
    what is cpu spike

    Thanks and Regards
    Narasimha A

  4. #4
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    Narasimha A : do not mix new questions in existing thread...
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  5. #5
    Join Date
    Aug 2010
    Location
    Singapore
    Posts
    197
    I believe you are comparing DB2 with Oracle. In DB2 users are different from schema, you don need password to access schema, all you need it access privilege on table.
    - Ananth
    DB2 DBA LUW
    "coming second, just means you are the first loser"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •