Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2006
    Posts
    1

    Unanswered: Revoke Command Not Working

    Hi

    I tried the following revoke command on Informix 7.23 DYNAMIC Server:

    REVOKE ALL on mtcp_test from tom;

    However tom is still able to select/delete/insert from the above table.

    Can anybody help me.

    User tom still have access to the table mtcp_test even after restarting the informix database engine using onmode -ky and oninit commands.

  2. #2
    Join Date
    Nov 2004
    Posts
    143
    Hi,

    Check whether the "public" has access to that table. If so, revoke the access priv from public and check. You dont need to bounce the engine.

    Bye

    Nitin

Posting Permissions

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