Professional Web Applications Themes

Preventing an ODBC from deleting data - Informix

How do prevent an ODBC user from deleting data ? thanks...

Sponsored Links
  1. #1

    Default Preventing an ODBC from deleting data

    How do prevent an ODBC user from deleting data ?

    thanks


    Sponsored Links
    brett simpson Guest

  2. #2

    Default Re: Preventing an ODBC from deleting data

    Further to my query :

    Im using the informix ODBC version 2.8

    I cant see any options to say don't delete.

    Do I need to find another 3rd party driver or try and limit the user on the
    database somehow ?

    Im not sure

    thanks


    "brett simpson" <bsimpsonactrol.com.au> wrote in message
    news:3f024fd1$1_1news.iprimus.com.au...
    > How do prevent an ODBC user from deleting data ?
    >
    > thanks
    >
    >

    brett simpson Guest

  3. #3

    Default Re: Preventing an ODBC from deleting data

    brett simpson wrote:
    >Further to my query :
    >
    >Im using the informix ODBC version 2.8
    >
    >I cant see any options to say don't delete.
    >
    >Do I need to find another 3rd party driver or try and limit the user on the
    >database somehow ?
    >
    >Im not sure
    >
    >thanks
    >
    >
    Proper way would be to restrict the user on the database.

    No doubt someone from Openlink is going to add to this.
    They claim to have ODBC with all kind of controls - I have not used them
    - no comments.

    HTH

    Michael
    >
    >"brett simpson" <bsimpsonactrol.com.au> wrote in message
    >news:3f024fd1$1_1news.iprimus.com.au...
    >
    >
    >>How do prevent an ODBC user from deleting data ?
    >>
    >>thanks
    >>
    >>
    >>
    >>
    >
    >
    >
    >

    Michael Krzepkowski Guest

  4. #4

    Default Re: Preventing an ODBC from deleting data

    Hmmmm

    How do you restrict the user on the database ?

    Im not sure how to do it ?

    thanks

    "brett simpson" <bsimpsonactrol.com.au> wrote in message
    news:3f024fd1$1_1news.iprimus.com.au...
    > How do prevent an ODBC user from deleting data ?
    >
    > thanks
    >
    >

    brett simpson Guest

  5. #5

    Default Re: Preventing an ODBC from deleting data

    Easy - revoke sql delete privlage from specific username and use
    UID=username in the ODBC connection string when connecting to the database
    instance. Same for OLE-DB.

    Noel

    "brett simpson" <bsimpsonactrol.com.au> wrote in message
    news:3f024fd1$1_1news.iprimus.com.au...
    > How do prevent an ODBC user from deleting data ?
    >
    > thanks
    >
    >

    Noel Guest

  6. #6

    Default Re: Preventing an ODBC from deleting data

    "brett simpson" <bsimpsonactrol.com.au> wrote in message news:<3f02543f$1_1news.iprimus.com.au>...
    > Further to my query :
    >
    > Im using the informix ODBC version 2.8
    >
    > I cant see any options to say don't delete.
    >
    > Do I need to find another 3rd party driver or try and limit the user on the
    > database somehow ?
    >
    > Im not sure
    >
    > thanks
    >
    >
    > "brett simpson" <bsimpsonactrol.com.au> wrote in message
    > news:3f024fd1$1_1news.iprimus.com.au...
    > > How do prevent an ODBC user from deleting data ?
    > >
    > > thanks
    > >
    > >

    I suspect that you are looking for some degree of conditionality re.
    the use of DELETE across a variety of user profiles and client
    applications combinations. If this is the case, then you certainly
    need a Driver with an in-built rules engine that will allow you to set
    conditional DELETE privileges across your desired profiles (and
    enforce this server side so it cannot be violated on the client via
    ODBC settings reconfiguration).

    OpenLink's Multi-Tier Drivers will certainly offer you this sort of
    granularity.

    The Drivers are available on a free evaluation basis from
    [url]http://www.openlinksw.com[/url]

    Kingsley Idehen
    OpenLink Software
    Kingsley Idehen Guest

Similar Threads

  1. Replies: 1
    Last Post: October 21st, 06:44 PM
  2. Preventing Users from Deleting Drafts
    By RoseyGren in forum Macromedia Contribute General Discussion
    Replies: 3
    Last Post: February 22nd, 09:17 AM
  3. Preventing Distiller from deleting PostScript file(s) created by PDFMaker
    By Gary_Beatty@adobeforums.com in forum Adobe Acrobat Windows
    Replies: 3
    Last Post: April 26th, 01:32 PM
  4. get Data into MySQL via ODBC
    By Ivo Angelo Carobbio in forum IBM DB2
    Replies: 0
    Last Post: September 8th, 09:09 AM
  5. deleting specific data after a set time
    By dan in forum Microsoft Access
    Replies: 0
    Last Post: July 9th, 09:28 AM

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