Professional Web Applications Themes

MySQL permissions - MySQL

Hi all, i was wondering if its possible to do something with permissions in MySQL so that a user can only see a restricted set of data in all the tables? For example, if I have 10+ tables with data for several teams - how can i make it so that a particular team can only see data relating to them? is this maybe something that can be achieved with a UDF ? Kind regards T...

  1. #1

    Default MySQL permissions

    Hi all,

    i was wondering if its possible to do something with permissions in MySQL so
    that a user can only see a restricted set of data in all the tables?

    For example, if I have 10+ tables with data for several teams - how can i
    make it so that a particular team can only see data relating to them? is
    this maybe something that can be achieved with a UDF ?

    Kind regards

    T


    toffee Guest

  2. #2

    Default Re: MySQL permissions

    toffee wrote: 

    You can use a view. But you need MySQL 5.0 or later.


    --
    ==================
    Remove the "x" from my email address
    Jerry Stuckle
    JDS Computer Training Corp.
    net
    ==================
    Jerry Guest

  3. #3

    Default Re: MySQL permissions

    On Sat, 14 Oct 2006 04:59:21 +0100, "toffee" <com>
    wrote:
     

    Rescheme your data so that there is a different (set of) table/s for
    each user.

    Add a different MySql user for each user.
    Allocate MySql table per user table permissions.
    PHP script to change user/table name/s used for each logged-in user.
    --
    Locate your Mobile phone: <http://www.bizorg.co.uk/news.html>
    Great gifts: <http://www.ThisBritain.com/ASOS_popup.html>
    David Guest

  4. #4

    Default Re: MySQL permissions

    David Quinton wrote:
     
    >
    > Rescheme your data so that there is a different (set of) table/s for
    > each user.
    >
    > Add a different MySql user for each user.
    > Allocate MySql table per user table permissions.
    > PHP script to change user/table name/s used for each logged-in user.[/ref]

    In my opinion, that is a lazy (and complicated) method of doing security. There is too
    much duplication, and the resulting database schema would be illogical.Not to mention
    the fact that a schema change in one of these 'duplicated' tables would require applying
    the schema change multiple times.

    Also, your solution does not provide an elegant method of hierachical security
    (operators, supervisors, managers, etc).

    --

    Murdoc Guest

  5. #5

    Default Re: MySQL permissions

    On Mon, 16 Oct 2006 08:37:29 +0000 (UTC), "Murdoc"
    <com> wrote:
     

    I agree with you. Apologies.
    --
    Locate your Mobile phone: <http://www.bizorg.co.uk/news.html>
    Great gifts: <http://www.ThisBritain.com/ASOS_popup.html>
    David Guest

Similar Threads

  1. Replies: 2
    Last Post: February 14th, 10:54 AM
  2. Replies: 1
    Last Post: January 23rd, 12:06 PM
  3. Strange MySQL permissions problem
    By JR in forum MySQL
    Replies: 2
    Last Post: August 4th, 09:17 AM
  4. Contribute permissions vs. network permissions
    By ghope in forum Macromedia Contribute Connection Administrtion
    Replies: 2
    Last Post: February 21st, 08:18 PM
  5. Replies: 0
    Last Post: January 29th, 02:03 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