Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2003
    Location
    canada
    Posts
    230

    Unanswered: connect privilege problem for new user!!!!!!!!

    I am working with DB2 v8.2.2 and AIX 5.3

    Hi,

    after creating new user in the system it seems by default it has "connect" privilage to database (db2 connect to xxxxx was successfull), I tried to revoke the privilege I get error that:

    SQL0556N An attempt to revoke a privilege from "MMTEST" was deniede because
    "MMTEST" does not hold this privilege. SQLSTATE=42504.

    could you please somebody tell me how come?

    how can I revoke the "connect" privilege from new user?

    Thank you in advance for your help.

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Check the privileges of the PUBLIC "group".

  3. #3
    Join Date
    Sep 2003
    Location
    canada
    Posts
    230
    Quote Originally Posted by n_i
    Check the privileges of the PUBLIC "group".
    Hi n_i

    when I revoke the connect privilege from public yes mmtest userid does not have privilege but it effects to all userids in our environment (am I right?) that I do not like it, I want revoke just "MMTEST" userid.

  4. #4
    Join Date
    Jul 2002
    Location
    ATL
    Posts
    170
    By default public has connect preveleges.
    If you want to revoke connect prevelege to a perticular user you have to
    1. Revoke connect from public.
    2. Frabt connect to only people that can be conencted.

    Hope it helps

  5. #5
    Join Date
    Sep 2003
    Location
    canada
    Posts
    230
    Quote Originally Posted by koganti
    By default public has connect preveleges.
    If you want to revoke connect prevelege to a perticular user you have to
    1. Revoke connect from public.
    2. Frabt connect to only people that can be conencted.

    Hope it helps

    Thank you all for your help.

Posting Permissions

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