Professional Web Applications Themes

Create user in DB2 - IBM DB2

I want to know that how to create a new user in DB2 database and set the password for it. Also, after set how to change the password. -- Posted via [url]http://dbforums.com[/url]...

  1. #1

    Default Create user in DB2


    I want to know that how to create a new user in DB2 database and set the
    password for it.



    Also, after set how to change the password.


    --
    Posted via [url]http://dbforums.com[/url]
    rupesh_nagar Guest

  2. #2

    Default Re: Create user in DB2

    "rupesh_nagar" <member40194dbforums.com> wrote in message
    news:3386143.1063897457dbforums.com...
    >
    > I want to know that how to create a new user in DB2 database and set the
    > password for it.
    >
    >
    >
    > Also, after set how to change the password.
    All users and passwords must be established at the operating system level.
    Then you can use the "grant" SQL command to provide access (see the SQL
    Reference manual). The Control Center also offers a GUI interface to grant
    access to users.


    Mark A Guest

  3. #3

    Default Re: Create user in DB2

    Rupesh,

    DB2 uses the underlying operating system security (or optionally a
    framework such as Kerberos) to manage user IDs and passwords.

    So if you want to create a new user on (for example) Linux you'd add a new
    user using the standard OS tools (either command line or GUI).

    Access to DB2 objects, and other database privileges, can then be granted
    to either individual user IDs or groups (again OS groups).

    HTH

    Phil Nelson

    On Thu, 18 Sep 2003 11:04:17 -0400, rupesh_nagar wrote:
    >
    > I want to know that how to create a new user in DB2 database and set the
    > password for it.
    >
    >
    >
    > Also, after set how to change the password.
    Philip Nelson Guest

Similar Threads

  1. Create User Controls dynamically
    By David Lozzi in forum ASP.NET Data Grid Control
    Replies: 2
    Last Post: October 19th, 08:26 AM
  2. Create an xml to allow a user to change listings
    By Si Fi in forum Macromedia Flash Data Integration
    Replies: 4
    Last Post: September 17th, 10:15 PM
  3. How do I create a Windows User Account using CF?
    By 3Deviants in forum Coldfusion - Getting Started
    Replies: 8
    Last Post: April 1st, 09:52 AM
  4. Create user in Unix shell
    By Matthew in forum Linux / Unix Administration
    Replies: 3
    Last Post: June 4th, 09:16 PM
  5. How and where to create User-Defined functions
    By Serge Rielau in forum IBM DB2
    Replies: 0
    Last Post: June 30th, 05:16 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139