Results 1 to 7 of 7

Thread: create new user

  1. #1
    Join Date
    Jun 2006
    Posts
    13

    Unanswered: create new user

    Iam new to this forum.I want to know how to create a new user in db2 by query language.If i Use the query create user username,it shows the following error, An unexpected token "user" was found following "create ".so provide me solution.

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    probably best to ask this question in the DB2 forum.....
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Dec 2005
    Posts
    273
    you can't create an user in DB2. You must already have an user-ID assigned to use DB2. ( assigned by UNIX , TSO-login , RACF .... depending on the platform you use ).
    To control access to DB2-resources for that ID, you may use the GRANT and REVOKE - statements of DB2

  4. #4
    Join Date
    Jun 2006
    Posts
    13

    create new user

    Tell me what are the other ways or methods to create a new user

  5. #5
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    The user (or group) must be created in the operating system. How that is done depends on the operating system you are using.

    Once the user is created by the operating system, then you may grant DB2 privledges to that user or group.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  6. #6
    Join Date
    Sep 2004
    Location
    Belgium
    Posts
    1,126
    On what platform are you?
    --_Peter Vanroose,
    __IBM Certified Database Administrator, DB2 9 for z/OS
    __IBM Certified Application Developer
    __ABIS Training and Consulting
    __http://www.abis.be/

  7. #7
    Join Date
    Jun 2006
    Posts
    13
    Iam in Windows2000 platform.

Posting Permissions

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